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

102 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
lustrates93946(None) 
lustrate8310441lustrate_
lustrated1037961lustrated
australes9317762australes
castrates11312672castrates
frustrates1345002frustrates
illustrates1173362illustrates
lustres73013232lustr__es
outrates82421372ou_trates
substrates12168552substrates
australs8359533austra_ls
balustrades1451873balustrades
busticates1456613busticates
butyrates1446083butyrates
castrate10313863castrate_
castrated1239513castrated
castrater1148523castrater
castraters1246473castraters
castratos1147633castratos
citrates102315093_citrates
cultrate10310873cultrate_
cultrated1248223cultrated
curates95323833cu__rates
disrates91118153dis_rates
dustrags1044943dustra_gs
elutriates1045003elu_triates
estates74520183_est_ates
filtrates1247733filtrates
fluctuates1543073fluctuates
frustrate1245583frustrate_
frustrated1444103frustrated
fumarates1445393fumarates
fustigates1445143fustigates
gestates93213733gest_ates
illustrate1073443illustrate_
illustrated1262733illustrated
instates81615833inst_ates
lacerates112413773lacerates
lactates10311223lact_ates
levirates1247493levirates
liberates111012943liberates
librates103412953l_ibrates
liftgates1343513liftgates
literates91415653literates
lucubrates1443163lucubrates
lusterwares1452093lusterwares
lustra6358893lustra___
lustral7339653lustra__l
lustrating1147783lustrating
lustration1048353lustration
lustrations1147623lustrations
lustre64011683lustr__e_
lustred8359053lustr__ed
lustrings10245553lustrings
lustrous877803lustr_ous
lustrums1044663lustr_ums
luxates1436973lu__xates
luxuriates1742913luxuriates
lysates10317473lys__ates
misrates101318243mis_rates
mistraces13312293mistraces
muskrats1444313muskrat_s
mutates92215793mu_t_ates
nitrates82516223_nitrates
numerates11199573numerates
nutates73214973nu_t_ates
outdates93114743ou_tdates
outraces102217863ou_traces
outrages92215933ou_trages
outrate72323183ou_trate_
outrated92219313ou_trated
outraves112313833ou_traves
outskates13177153outskates
outstates91710753outstates
outtrades1077693outtrades
pastorates12410143pastorates
postdates1248863postdates
prostrates12411993prostrates
pustulates1276213pustulates
quadrates19117803quadrates
restates83423433rest_ates
rostrate8313843rostrate_
rusticates1248053rusticates
states64337083__st_ates
strafes104516003__strafes
strakes114218073__strakes
stratas73013583__stratas
straths102711723__straths
stratus73011733__stratus
striates83417083__striates
substates111410333subst_ates
substrate11178793substrate_
susurrates1043753susurrates
tartrates979563tartrates
testates83615453test_ates
titrates82314663_titrates
ulcerates1148853ulcerates
uncrates10314563_uncrates
unstates81314993unst_ates
uprates93814863_u_prates
upstates10189643upst_ates
urates65027763_u__rates

Search took 7 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 Filter1786911486410.420425454.8
2DLD Change Limit1486411026.06324516.1
3Display Results1021020.0333090.9
 (SQL Overall)1786911026.51627423.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.