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

188 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
statutes836889(None) 
statues74614901statu_es
statures83711111statures
statuses8409541statuses
statute7419321statute_
salutes73716252s_alutes
sautes63924912s_a_utes
stactes91914632sta_ctes
states64337082sta__tes
statices102712342statices
statives112710792statives
statue66015322statu_e_
statued8459892statu_ed
statuettes1042922statuettes
stature74410682stature_
status65515212statu__s
steatites939842steatites
acutes83917723__acutes
apatites10311293apatites
astatines9310343astatines
attunes737823at_tunes
battues94610193battu_es
destitutes1156523destitutes
enstatites1044523enstatites
estates74520183esta__tes
features11310333features
flatuses1137173flatuses
hiatuses1135773hiatuses
institutes1046053institutes
lattes65324203_lat_tes
mattes85624533_mat_tes
matures9314313_matures
meatuses1038203meatuses
natures7311963_natures
ossatures943423ossatures
ratites74920683_ratites
restitutes1057833restitutes
salute64418023s_alute_
saluted84511713s_aluted
saluter73512453s_aluter
saluters8319863s_aluters
samites93118713s_amites
sapotes9313943s_apotes
sates54949323s_a__tes
satiates8314633satiates
satires72617573s_atires
saturates9811603s_aturates
sauces84919503s_a_uces
saute55028083s_a_ute_
sauted74119603s_a_uted
savates10312953s_avates
scathes124515713scat_hes
scatted103512773scat_ted
scatter93815173scat_ter
scatters103612753scat_ters
scatts85914663scat_t_s
scutes85219193s__cutes
seatmates1157823seatmates
shamuses1336153shamuses
shatter103615703shat_ter
shatters113313913shat_ters
shutes93518223s__hutes
situates8310373s_ituates
situses72710493s_ituses
skates104219403ska__tes
skatoles1236143skatoles
slatches131511533slatches
slates64934063sla__tes
slatted84015183slat_ted
smaltites1145743smaltites
smatter93613333smat_ter
smatters104011713smat_ters
snatches131410713snatches
snathes104816493snat_hes
solutes73515263s_olutes
spates85028173spa__tes
spathes125116533spat_hes
spatted104014143spat_ted
spatter94016523spat_ter
spatters103914703spat_ters
spatulas1045473spatulas
spatzles1935303spatzles
stabiles10311403stabiles
stables93219073sta_bles
stacte82113913sta_cte_
staddles10258693staddles
stades74626243sta__des
stages75629493sta__ges
staggies101210323staggies
stagnates1046733stagnates
staithes1138953staithes
stakes103927293sta__kes
stales65538293sta__les
stances93715963sta_nces
stanches132312793stanches
standees93310143standees
stanes64933403sta__nes
stanines85115673stanines
stannites947023stannites
stapedes11197753stapedes
stapes85028733sta__pes
staples93617213sta_ples
starches131912913starches
stares66038753sta__res
starets73515923staret_s
starlets81610083starlets
started84217323sta_rted
starter73817883sta_rter
starters83714773sta_rters
startles82111963startles
starts65423123sta_rt_s
startups1033893startu_ps
starves104614553sta_rves
stases64225563sta__ses
stashes103916173sta_shes
state56237333sta__te_
stated75427833sta__ted
stateless937563stateless
stater64427563sta__ter
staters73922343stat_ers
statice92614033statice_
statics93314533stat_ics
statins73719773stat_ins
stations82415223stations
statisms1039543statisms
statists8310163statists
stative102612933stative_
stators73915583stat_ors
stats55933363sta__t_s
statuaries1054603statuaries
statuary1144033statuary
statuette943263statuette
statusy10455423statu_sy
statutory1242413statutory
staves94525193sta__ves
stearates939453stearates
steatite8310583steatite_
stetted82610403stet_ted
stipites1039653stipites
stipules1037053stipules
stitches131410593stitches
stithies1139233stithies
stomates10313343stomates
stotted83511423stot_ted
stotts64612863stot_t_s
stoures74614163st_oures
stouten7307333st_outen
stoutens8255273st_outens
stouter74012053st_outer
stoutest837613st_outest
stouts65019003st_out_s
stratums10266803stratu_ms
stratus73011733stratu__s
striates83417083striates
struts65616803st_rut_s
strutted946343strutted
strutter846503strutter
strutters955693strutters
stupes84116953s__tupes
stutter72911463stut_ter
stutters83210473stut_ters
stylites11168693stylites
styluses11204773styluses
subcutes1238583subcutes
sutures7314223s_utures
swatches16169963swatches
swathes134115513swat_hes
swatted114110693swat_ted
swatter104113323swat_ter
swatters113911793swat_ters
taluses7311213_taluses
tartufes1164153_tartufes
tastes64126423_ta_stes
tates55444983_ta__tes
tatted74920533_tat_ted
tatter64024573_tat_ter
tatters74520483_tat_ters
tatties74120343_tatties
tattles73616283_tattles
taupes8212673_ta_upes
tauted75317113_ta_uted
tauten64311893_ta_uten
tautens7317843_ta_utens
tauter64318023_ta_uter
tautest72612443_ta_utest
tauts56125513_ta_ut_s
taxites1449673_taxites
tsatskes1242013tsatskes

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 Limit1461621886.54622328.4
3Display Results1881880.0762473.7
 (SQL Overall)1786911887.04525364.2
 
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.