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

159 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
recrown1225757(None) 
decrown13206051decrown
recrowns13246141recrowns
regrown11237361regrown
beclown1435422beclown
becrowd1555172becrowd
crown105620082__crown
decrowns14265062decrowns
reckon123010542recko_n
recoin84320292rec_oin
recon75624242rec_o_n
recross989832recross
recrowned1564852recrowned
redrawn11245952redrawn
reflown13316212reflown
regrow10309882regrow_
regrows11269152regrows
renown9369982re_nown
reshown13257902reshown
resown94112922re_sown
uncrown1236322uncrown
beckon14309383becko_n
beclowns1544683beclowns
becrawl1444583becrawl
becrowds1683773becrowds
bedgown1443773bedgown
begroan1036103begroan
bestrown1345193bestrown
bicron103710773bicro_n
brown105619533__brown
clown105214733__clown
croon75522783__croon
crow96428133__crow_
crowd115815623__crowd
crowns115615113__crowns
crows105727313__crows
dacron94310693dacro_n
decrowned1663653decrowned
discrown1445283discrown
drown95515823__drown
embrown1454793embrown
escrow1135913escrow_
escrows1235803escrows
frown115415973__frown
grown95317353__grown
heroin94420593he_roin
heron85025503he_ro_n
imbrown1443883imbrown
ingrown1145393ingrown
letdown1144263letdown
macron103615673macro_n
micron103714283micro_n
necrose939723necrose
neuron6310373neuro_n
newmown1542283newmown
perron83216623perro_n
preshown16255633preshown
raccoon1176163raccoon
racon75422143rac_o_n
racoon83814473rac_oon
readorn8310483readorn
reason62616333reaso_n
reavow1235723reavow_
reavows1335273reavows
reborn810016963re_born
rechew14310213rechew_
rechews1537293rechews
rechose121312043rechose
rechosen13127033rechosen
reckons13269653reckons
reclean938523reclean
recoal84117973rec_oal
recoat84024273rec_oat
recock145112723rec_ock
recode93618713rec_ode
recoil84016723rec_oil
recoins94019243rec_oins
recomb1238873rec_omb
recons84922993rec_ons
recook125513923rec_ook
recooks134711233recooks
recopy1339043rec_opy
record96117433rec_ord
records105213923records
recork126315493rec_ork
recorks134813023recorks
recount9315173rec_ount
recoup10810373rec_oup
recrate92621663recrate
recreant10311283recreant
recrowning1645213recrowning
recruit939773recruit
recto74520803recto__
rector84019753recto_r
rectors93520523rectors
rectory123512733rectory
rectos85718783recto_s
redon65424883re_do_n
redowa1038453re_dowa
redraw10269853redraw_
redraws11218473redraws
redrew10309513redrew_
redroot8312903redroot
redrove11249423redrove
reflow12379653reflow_
reflows13258983reflows
refrain10310043refrain
refront10313263refront
refroze1956223refroze
refrozen2063873refrozen
region74614903regio_n
reglow10339403reglow_
reglows11288843reglows
regreen8309043regreen
regrew10388563regrew_
regroom1077303regroom
reground1045073reground
regroup1095173regroup
regrowing1436673regrowing
regrowth1544033regrowth
rejoin134012243re_join
reloan6415693re_loan
renowns10277833re_nowns
replow114210343replow_
replows12329703replows
repro75315913repro__
reprobe112310133reprobe
reproof1238783reproof
repros84216003repro_s
reprove122911073reprove
reran57329103re_r_an
reroll6412683re_roll
reroof9315003re_roof
rerose63320843re_rose
rerun58722153re_r_un
resawn9399953re_sawn
rescreen1046703rescreen
resewn9459813re_sewn
reshow123111433reshow_
reshows132510453reshows
resow88217243re_sow_
resows93915353re_sows
retorn610923433re_torn
retrain7615423retrain
retro55020953retro__
retros63820193retro_s
rewon86920583re_wo_n
reworn98122203re_worn
rewrote1039123rewrote
rockoon1345653rockoon
rubdown1383893rubdown
rundown1165443rundown
serow86720443se_row_
serows96016393se_rows
strown96812093_strown
teardown1243763teardown
thrown1214911443_thrown
uncrowns1344363uncrowns
upgrown1343853upgrown

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.390458182.1
2DLD Change Limit1340271597.12618808.2
3Display Results1591590.0463456.5
 (SQL Overall)1786911597.56223630.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.