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

114 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
retreaded113705(None) 
rethreaded1543271rethreaded
retreated10312621retreated
pretreated1347622pretreated
recreated12412532recreated
redheaded1545082redheaded
redreamed1345022redreamed
regraded113410762regr_aded
repleaded1336292repleaded
reteamed1138012ret_eamed
retraced111413022retr_aced
retread849002retrea__d
retreads937822retread_s
retreater9310202retreater
treaded95014282__treaded
untreaded1137982untreaded
beheaded1536373be_headed
bereaved1446403be_reaved
besteaded1345043besteaded
betrayed1436303betr_ayed
breaded115014063__breaded
decreased1345453decreased
degraded12288323degr_aded
degreased1244713degreased
deleaded1148333de_leaded
detruded1134883detr_uded
dreaded103612023__dreaded
entreated10310973entreated
estreated1039553estreated
fatheaded1744273fatheaded
hotheaded1744853hotheaded
intreated10312663intreated
pervaded1535373pe_rvaded
precreased1544413precreased
pretended1337193pret_ended
reblended1355203reblended
rebreed104611073rebre__ed
receded112713043re_ce_ded
recleaned1236583recleaned
recrated112918603recr_ated
recreate10313603recreate_
recreates11313363recreates
redressed1137773redressed
reeded84022563re__e_ded
reerected1238613reerected
reframed1437853refr_amed
refreshed1685613refreshed
regeared1039433re_geared
regrade92612033regr_ade_
regrades103212173regr_ades
regrated102816333regr_ated
regreened1145553regreened
regreeted1136173regreeted
regressed1138113regressed
regretted1137233regretted
reheated122415003re_heated
reinvaded1444073reinvaded
reiterated11410153reiterated
released9310243re_leased
reloaded1059103re_loaded
remended123010393re_mended
renegaded1244603renegaded
repealed113211873re_pealed
repeated113117443re_peated
repleader1245393repleader
repressed12610103repressed
reread71715433re_rea__d
rereads81512293re_read_s
rerented92516163re_rented
resealed92713963re_sealed
reseated93220263re_seated
reseeded1038093re_seeded
respaded1238133re_spaded
restressed1146643restressed
retaped103814283ret__aped
retarded102410753ret_arded
retaxed153512233ret__axed
retested92212533ret_ested
rethread1245353rethrea__d
rethreads1344483rethread_s
retotaled1045953retotaled
retrace91417343retr_ace_
retracer101411883retr_acer
retraces101417273retr_aces
retracked1657453retracked
retracted12410953retracted
retrained10411313retrained
retreading12128483retreading
retreat7317533retrea__t
retreaters1047543retreaters
retreats8311413retrea_ts
retrenched1654393retrenched
retried84419153retr__ied
retrieved1385093retrieved
retrimmed1443673retrimmed
retroacted1366133retroacted
retroceded1443473retroceded
retrograded1453103retrograded
revealed123211213re_vealed
reweaved1535953re_weaved
rewedded1434513re_wedded
rewelded1335893re_welded
serenaded11215933se_renaded
steaded92811673_st_eaded
streaked13228453_streaked
streamed11258903_streamed
threaded1366323_threaded
traded85717683__tr_aded
treader84113833__treader
treadled1067123__treadled
treated83618703__treated
trended94011763__trended
unthreaded1543533unthreaded
untreated10312903untreated

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411147.42320024.4
3Display Results1141140.0462478.3
 (SQL Overall)1786911147.88922650.7
 
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.