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

121 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
recrowns1324614(None) 
decrowns14265061decrowns
recrown12257571recrown_
beclowns1544682beclowns
becrowds1683772becrowds
crowns115615112__crowns
decrown13206052decrown_
reckons13269652recko_ns
recoins94019242rec_oins
recons84922992rec_o_ns
recross989832recro_ss
recrowned1564852recrowned
regrown11237362regrown_
regrows11269152regrow_s
renowns10277832re_nowns
uncrowns1344362uncrowns
beckons15279143becko_ns
beclown1435423beclown_
becrawls1543623becrawls
becrowd1555173becrow_d
bedgowns1543113bedgowns
begroans1145503begroans
bicrons113410473bicro_ns
browns116415633__browns
clowns114810113__clowns
croons85418423__croons
crowds124910763__crowds
crown105620083__crown_
crows105727313__crow_s
dacrons103211033dacro_ns
decrowned1663653decrowned
discrowns1544663discrowns
drowns105612333__drowns
embrowns1544043embrowns
escrows1235803escrow_s
frowns126011393__frowns
heroins103518013he_roins
herons94820543he_ro_ns
imbrowns1543263imbrowns
letdowns1243483letdowns
macrons113514893macro_ns
microns113814783micro_ns
necroses10310563necroses
necrosis1048883necrosis
neurons7410443neuro_ns
perrons93115483perro_ns
raccoons1265453raccoons
racons84319343rac_o_ns
racoons93912433rac_oons
readorns938283readorns
reasons72514943reaso_ns
reavows1335273reavow_s
rechews1537293rechew_s
reckon123010543recko_n_
recleans1037513recleans
recoals94214623rec_oals
recoats92616643rec_oats
recocks154711463rec_ocks
recodes102918633rec_odes
recoils93814873rec_oils
recoin84320293rec_oin_
recombs1336753rec_ombs
recon75624243rec_o_n_
recooks134711233rec_ooks
records105213923rec_ords
recorks134813023rec_orks
recount9315173rec_ount
recounts1038773rec_ounts
recoups1188843rec_oups
recrates102420373recrates
recreant10311283recreant
recreants1146623recreants
recrosses1138373recrosses
recrowning1645213recrowning
recruits1036563recruits
rectors93520523recto_rs
rectos85718783recto__s
redons75222183re_do_ns
redowas1138393re_dowas
redrawn11245953redrawn_
redraws11218473redraw_s
redroots937753redroots
reflown13316213reflown_
reflows13258983reflow_s
refrains1139593refrains
refront10313263refro_nt
refronts1137773refronts
regions83613473regio_ns
reglows11288843reglow_s
regreens9257453regreens
regrooms1196013regrooms
reground1045073reground
regroups11104383regroups
regrow10309883regrow__
regrowing1436673regrowing
regrowth1544033regrowth
regrowths1642433regrowths
rejoins143111383re_joins
reloans7313133re_loans
renown9369983re_nown_
replows12329703replow_s
reprobes121910293reprobes
reproofs1346063reproofs
repros84216003repro__s
reproves132011473reproves
rerolls739943re_rolls
reroofs1037943re_roofs
reruns66413743re_r_uns
rescreens1144863rescreens
reshown13257903reshown_
reshows132510453reshow_s
resown94112923re_sown_
resows93915353re_sow_s
retrains8314533retrains
retros63820193retro__s
rockoons1445003rockoons
rubdowns1473083rubdowns
rundowns1284533rundowns
serows96016393se_row_s
teardowns1343043teardowns
uncrown1236323uncrown_

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.406440125.6
2DLD Change Limit1461621216.75021653.6
3Display Results1211210.0602016.7
 (SQL Overall)1786911217.21624763.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.