Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “ectypes” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

124 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
ectypes143480(None) 
ecotypes1545051ecotypes
ectype1334281ectype_
cotypes1437942cotypes
ecdyses1333412ecdyses
ecotype1444842ecotype_
ectases92911672ectases
ectypal1442772ectypal
etapes85415292e_tapes
neotypes1344522neotypes
retypes12308622retypes
types105721062__types
actives12311523actives
biotypes1544683biotypes
blypes13357543_blypes
capes95441923_c_apes
cepes94424463_c_epes
cerotypes1644733cerotypes
cetanes9315133cetanes
cetes75731103cet__es
chapes135421873_chapes
chyles144813283_chyles
chymes165912153_chymes
clepes104214623_clepes
clypei1334163_clypei
clypeus1433243_clypeus
copes97747103_c_opes
cotype1346823cotype_
coupes105022523_coupes
coypus13389303_coypus
crapes104727693_crapes
crepes105419343_crepes
cripes105120873_cripes
crypts13397743_crypts
cymes1210118923_c_ymes
cypres1338523_c_ypres
decrypts1642943decrypts
ecartes94212563ecartes
ecdysis1343223ecdysis
eches106322163ec__hes
echoes114715523ec_hoes
eclipse1144183eclipse
eclipses1244213eclipses
ecotages1136973ecotages
ecotones1039493ecotones
ecotypic1744413ecotypic
ectasis9249613ectasis
ectopia1147693ectopia
ectopias1248273ectopias
ectopic1338153ectopic
elopes85918163e_lopes
emydes1236173e_mydes
encrypts1542983encrypts
entases72816273entases
entices91616333entices
entires71517783entires
entrees71813773entrees
entries71523163entries
enzymes2164413enzymes
epitopes1246973epitopes
escapes113811673escapes
estates74520183estates
estops84011223estop_s
etape74413703e_tape_
etches114217763e_tches
ethynes13377573ethynes
etudes73811603e_tudes
etwees9348793e_twees
eyes75837883e__y_es
eyres84921773e__yres
genotypes1544683genotypes
hectares1338853hectares
hypes135818673__hypes
ictuses938303ictuses
isotypes13234853isotypes
lectotypes1753633lectotypes
lectures101310153lectures
metopes11311363metopes
mistypes15116713mistypes
neotype1244593neotype_
octanes91111393octanes
octaves12316963octaves
octopus1144813octopus
octuples1244133octuples
octyls11135323octy_ls
pectases122411193pectases
pectates122213953pectates
pectines121914683pectines
pectizes21229793pectizes
pretypes15337263pretypes
recipes113314463rec_ipes
restyles1139193restyles
retapes93917423retapes
retype11399143retype_
retyped13367303retyped
scapes105122263sc_apes
scopes104719593sc_opes
scrapes116217663scrapes
scythes15356523scythes
serotypes1445323serotypes
slypes114410483_slypes
stapes85028733_stapes
stipes84524053_stipes
stopes84525893_stopes
stupes84116953_stupes
styes86316523_sty_es
styles94418653_styles
subtypes1544553subtypes
tapes75838603__tapes
tectites1039993tectites
teletypes14114953teletypes
tintypes1343273tintypes
topes76941763__topes
tyees86019453__tyees
tyes76433373__ty_es
tykes125817063__tykes
tynes85920303__tynes
type96223743__type_
typed115815453__typed
typey135511883__typey
typos106015813__typos
typps12549303__typps
tyres84725233__tyres
watapes12228383watapes

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.406440125.6
2DLD Change Limit1340271246.59620319.4
3Display Results1241240.0462695.7
 (SQL Overall)1786911247.04825353.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.