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 “custodes” 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.

110 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
custodes113665(None) 
cestodes1138201cestodes
custodies1245961custodies
cestode1037962cestode_
cuspides13306942cuspides
custody1334092custod_y
customer1245382customer
customers1344782customers
customs11348262custo_ms
custos84014312custo__s
gustoes879872gusto_es
burstones1187153burstones
bustles93816323bust_les
capstones1347373capstones
cascades13128553cascades
caseoses1039293caseoses
castes85631863cast__es
castles94917733cast_les
castoffs1644043castoffs
castors94919443casto_rs
cathodes1439393cathodes
centones10313663centones
cestoids11308273cestoids
cestos84718093cesto__s
cestuses1038083cestuses
ciscoes113610733cisco_es
cistuses1038283cistuses
citoles9312553c_itoles
cladodes1245323cladodes
codes86247293c___odes
commodes1539093commodes
corrodes111310333corrodes
cosmoses1239703cosmoses
costumes1258013costumes
croustades1344083croustades
crunodes1144973crunodes
crusades1146333crus_ades
crusadoes1243043crusadoes
crustose1045503crustose_
cuittles1045903cuittles
culottes1076293culottes
cultches15316533cultches
cultures10310153cultures
cultuses1037753cultuses
curbstones1443903curbstones
curtsies1038733curtsies
cuscuses1235863cuscuses
cuspids12427113cuspid_s
cusses84522773cus__ses
cussos84210003cusso__s
custards11338393custards
custodial1244353custodial
custodian1243763custodian
custodians1352943custodians
custom104010273custo__m
customise1344863customise
customises1444803customises
customizes2364173customizes
cutches143216463cu_tches
cutes79438323cu_t__es
cuties84927363cu_t_ies
cutises94414913cu_tises
cutoffs1533603cu_toffs
cutouts938033cu_touts
cutover1235283cu_tover
cutovers1335123cu_tovers
cuttages11297223cuttages
cutties93118843cu_tties
cuttles93613923cu_ttles
cystines1339473cystines
cystoids14306733cystoids
distomes11314163distomes
duotones937643duotones
dustoffs1543163dustoffs
eusteles838043eusteles
histones11312803histones
hustles103414173hust_les
justices1737523justices
justles143311433just_les
kurtoses12105623kurtoses
lustres73013233lust_res
miscodes13310423miscodes
mudstones1245033mudstones
mustees94614923must_ees
ostoses71213553_ostoses
outdoes8313123ou_tdoes
outmodes11208963outmodes
outsides92513233outsides
outsoles8813113outsoles
pentodes11310363pentodes
pistoles102514723pistoles
postcodes1446153postcodes
pustules1038443pustules
restokes125213043restokes
restores85222993restores
rustles73416413rust_les
spodes94817433__spodes
stades74626243__stades
stodges9309083__stodges
stokes104821793__stokes
stoles63927673__stoles
stones65130033__stones
stopes84525893__stopes
stores65533663__stores
stoves93818923__stoves
subcodes1338143subcodes
subtones10311383subtones
sunstones947883sunstones
systoles1146483systoles
tussores8316533tussores

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621106.98320931.1
3Display Results1101100.0502200.0
 (SQL Overall)1786911107.45623966.1
 
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.