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

107 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
recrosses113837(None) 
recrossed1246511recrossed
crosses94220792__crosses
incrosses1146032incrosses
lacrosses1145312lacrosses
necroses10310562necro_ses
rearouses9310202rearouses
recesses10312322rec_esses
rechooses14107612rechooses
recross989832recro_s_s
redresses10410292redresses
reglosses1045342reglosses
regresses10310462regresses
represses11412142represses
uncrosses1146152uncrosses
ancresses1138413ancresses
cresses94219813__cresses
crosse85216303__crosse_
crossed105313893__crossed
crosser95015463__crosser
crossers103912703__crossers
crossest1012012123__crossest
declasses1246443declasses
decreases1237223decreases
depresses1259883depresses
drosses84513823__drosses
egresses949443_egresses
embosses1235963_embosses
engrosses1045473engrosses
eroses65327053_e_ro_ses
grosses84517683__grosses
heiresses1236963heiresses
incrossed1244743incrossed
karosses1236493_karosses
lacrosse1044123lacrosse_
leprosies1146803leprosies
necropsies1444743necropsies
necrose939723necro_se_
necrosed1137213necro_sed
necrosis1048883necro_sis
neuroses8310153neuro_ses
outcrosses1254703outcrosses
peeresses1138473peeresses
percusses1346503percusses
precesses13310463prec_esses
prechooses17116403prechooses
preciouses1446883preciouses
precreases1445653precreases
prosses94019513__prosses
rearouse839363rearouse_
rearoused1047093rearoused
recessed1139713rec_essed
rechoose13137343rechoose_
rechose121312043recho_se_
rechosen13127033recho_sen
reclothes1445643reclothes
recluses105111733rec_luses
recodes102918633rec_o_des
recopies12313733rec_opies
recourses1137733recourses
recrates102420373recr_ates
recreates11313363recreates
recrossing1386973recrossing
recrowned1564853recrowned
recrowns13246143recro_wns
rectories11314653rectories
recuses94619463rec__uses
redhorses1345653redhorses
rednesses10312313rednesses
redressed1137773redressed
redresser1056793redresser
redressers1145103redressers
refreshes1595953refreshes
reglossed1144003reglossed
regressed1138113regressed
regrooves1343863regrooves
rehouses11312113re_houses
remorses10311993re_morses
repasses101810373re_passes
reposes94021263re_po_ses
repossess1143703re_possess
repousses1146063repousses
repressed12610103repressed
represser1168953represser
repressers1256883repressers
reprises102615463repr_ises
reprobes121910293repro_bes
reprocess1345933reprocess
reprocesses1545153reprocesses
reproves132011473repro_ves
reraises8415643re_raises
rerises73525883re_r_ises
rerose63320843re_ro_se_
reroutes8312223re_routes
responses1147453responses
restresses1049313restresses
retrorse837623retrorse_
retrousse944613retrousse_
rockroses1545563rockro_ses
ryegrasses1442463ryegrasses
seeresses939053seeresses
sucroses1039933sucro_ses
testcrosses1351873testcrosses
topcrosses1442273topcrosses
uncrossed1236313uncrossed
xeroses143612823xe_ro_ses
zebrasses2043513zebrasses

Search took 9 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.470380193.6
2DLD Change Limit1486411077.50019818.8
3Display Results1071070.0462326.1
 (SQL Overall)1786911078.01622291.8
 
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.