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

135 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
reerected123861(None) 
preerected1545571preerected
reejected1955091reejected
reelected1238311reelected
coerected1447642coerected
erected103213992__erected
preelected1545782preelected
recreated12412532recreated
redefected1743852redefected
redirected1444772redirected
reenacted1236852reenacted
reerect92915882reerect__
reerects10319922reerect_s
reexecuted2062692reexecuted
refected142311662r_efected
reflected1547982reflected
refracted1557392refracted
regreeted1136172regreeted
regretted1137232regretted
rejected182710112r_ejected
rerented92516162r_erented
resected112514742r_esected
reselected1345632reselected
respected1438492respected
retracted12410952retracted
retreated10312622retreated
befretted1544373befretted
corrected1438113corrected
defected15289973_defected
deflected1635983deflected
dejected19307593_dejected
deprecated1646673deprecated
deselected1444083deselected
detected12289733_detected
detracted1357793detracted
directed1238233_directed
effected1744993_effected
ejected17297653__ejected
elected102812613__elected
erecter93113393__erecter
eructed10228653__eructed
expected2036743_expected
exsected1835673_exsected
ferreted1236333ferre_ted
neglected1354693neglected
overacted1539633overacted
perfected1736643perfected
praelected1544393praelected
preenacted1544973preenacted
preerect1259273preerect__
preerects1345413preerect_s
prelected1439133prelected
preselected1643963preselected
pretreated1347623pretreated
reacted103015713r_e_acted
rearrested1145123rearrested
rebreed104611073rebre__ed
recemented1546163recemented
rechecked2143973rechecked
recrated112918603recr_ated
recreate10313603recreate_
recreates11313363recreates
recruited1236453recruited
redacted12410243r_edacted
redefeated1544883redefeated
rednecked1743163rednecked
redrafted1435143redrafted
redreamed1345023redreamed
redressed1137773redressed
reedited10310083ree_dited
reeducated1484823reeducated
reeject16349623reeject__
reejects17336083reeject_s
reelect911515633reelect__
reelects103110883reelect_s
reelevated1445153reelevated
reemerged1354403reemerged
reemitted1245943reemitted
reerecting1339973reerecting
reested82916233r_e_ested
reexecute1862723reexecute_
reexecutes1962623reexecutes
refereed12149693refere__ed
referenced1676863referenced
reforested1445383reforested
refreshed1685613refreshed
refronted1336053refronted
regrafted1435243regrafted
regranted1137703regranted
regrated102816333regr_ated
regreened1145553regreened
regressed1138113regressed
regretter1045973regretter
reheated122415003r_eheated
reinfected1645253reinfected
reinjected2044443reinjected
rejectee17289623r_ejectee
rejecter17258943r_ejecter
relented92614943r_elented
relucted1138653r_elucted
remelted11310153r_emelted
renested92212953r_enested
reobjected2242253reobjected
reoriented1145343reoriented
repeated113117443r_epeated
repented112614983r_epented
repressed12610103repressed
repriced132610543repric_ed
reprinted1289043reprinted
requested1935893requested
reracked15169123r_eracked
rerecord1145373r_erecord
rerepeated1346193rerepeated
rerouted9311143r_erouted
reseated93220263r_eseated
resented92716963r_esented
resmelted1236033resmelted
respecter1347443respecter
restricted1348303restricted
resurrected1452673resurrected
retested92212533r_etested
retraced111413023retrac_ed
retracked1657453retracked
retreaded1137053retreaded
retreater9310203retreater
retrenched1654393retrenched
retroacted1366133retroacted
reverenced1676313reverenced
reverted122714713r_everted
revested122612243r_evested
revetted122210943r_evetted
rewetted12228353r_ewetted
secreted1138633secre_ted
selected1159783_selected
unelected1237823unelected

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 Limit1486411357.22020587.4
3Display Results1351350.0632142.9
 (SQL Overall)1786911357.70323197.6
 
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.