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

138 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
reelected123831(None) 
preelected1545781preelected
reejected1955091reejected
reerected1238611reerected
reflected1547981reflected
reselected1345631reselected
deflected1635982deflected
deselected1444082deselected
elected102812612__elected
neglected1354692neglected
praelected1544392praelected
preerected1545572preerected
prelected1439132prelected
preselected1643962preselected
redefected1743852redefected
reelect911515632reelect__
reelects103110882reelect_s
reelevated1445152reelevated
reenacted1236852reenacted
reexecuted2062692reexecuted
refected142311662r_efected
rejected182710112r_ejected
relented92614942r_elented
relucted1138652r_elucted
resected112514742r_esected
respected1438492respected
selected1159782_selected
unelected1237822unelected
beflecked2142653beflecked
coerected1447643coerected
collected1447973collected
defected15289973_defected
dejected19307593_dejected
deleted93314913_dele_ted
depleted12258723deple_ted
detected12289733_detected
effected1744993_effected
ejected17297653__ejected
electee92513243__electee
erected103213993__erected
expected2036743_expected
exsected1835673_exsected
eyeletted1342863eyeletted
inflected1546053inflected
neglecter1263633neglecter
nonelected1355693nonelected
pelleted1138203pelle_ted
perfected1736643perfected
preelect1249643preelect__
preelects1356083preelect_s
preenacted1544973preenacted
reacted103015713r_e_acted
reblended1355203reblended
recemented1546163recemented
rechecked2143973rechecked
recleaned1236583recleaned
recollected1643853recollected
recreated12412533recreated
redacted12410243r_edacted
redefeated1544883redefeated
redirected1444773redirected
rednecked1743163rednecked
reedited10310083ree_dited
reeducated1484823reeducated
reeject16349623reeject__
reejects17336083reeject_s
reelecting1338783reelecting
reelection12198633reelection
reeled74725533reel___ed
reelevate1245663reelevate_
reelevates1345633reelevates
reemerged1354403reemerged
reemitted1245943reemitted
reenlisted1144833reenlisted
reerect92915883reerect__
reerects10319923reerect_s
reested82916233r_e_ested
reexecute1862723reexecute_
reexecutes1962623reexecutes
reflated123514293refl_ated
reflect123913713reflect__
reflector1445733reflector
reflects13288873reflect_s
reflexed1975253refle_xed
refloated1347013refloated
refracted1557393refracted
regelated1139723regel_ated
regreeted1136173regreeted
regretted1137233regretted
reheated122415003r_eheated
reinfected1645253reinfected
reinjected2044443reinjected
rejectee17289623r_ejectee
rejecter17258943r_ejecter
relaced103517213r_elac_ed
related83327573r_el_ated
released9310243r_eleased
relegated1139763relegated
reletter81311023r_eletter
relisted9312623r_elisted
relocated12710813r_elocated
relocked15217743r_elocked
remelted11310153r_emelted
renested92212953r_enested
reobjected2242253reobjected
repeated113117443r_epeated
repented112614983r_epented
replaced133211403replac_ed
replanted1248063replanted
replated112817523repl_ated
repleaded1336293repleaded
repledged1443633repledged
replete92912993reple_te_
repletes102812473reple_tes
replevied1574373replevied
replicated1548773replicated
replotted1235823replotted
requested1935893requested
rereleased1143503rereleased
rerented92516163r_erented
rerepeated1346193rerepeated
reseated93220263r_eseated
reselect1059943reselect__
reselects1156413reselect_s
resented92716963r_esented
reslated93517523resl_ated
resmelted1236043resmelted
respecter1347443respecter
retested92212533r_etested
retracted12410953retracted
retreated10312623retreated
reverted122714713r_everted
revested122612243r_evested
revetted122210943r_evetted
rewetted12228353r_ewetted
rouletted1045053rouletted
selectee10910493_selectee
unselected1344973unselected

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.423422437.4
2DLD Change Limit1486411387.37320160.2
3Display Results1381380.0632190.5
 (SQL Overall)1786911387.85922737.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.