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

112 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
reselect105994(None) 
deselect1147521deselect
preselect1346981preselect
reelect911515631re_elect
reselects1156411reselects
deselects1244492deselects
preelect1249642pre_elect
preselects1464362preselects
redefect1446052redefect
reeject16349622re_eject
reelects103110882re_elects
reerect92915882re_erect
reflect123913712re_flect
resect84424702res__ect
reselected1345632reselected
respect11412032res_pect
select82621172__select
basilect1245903basilect
beseech1453873bese_ech
deflect13399973de_flect
derelict11138483derelict
deselected1444083deselected
elect74327033___elect
eyelet9514533_eyele_t
neglect1047363ne_glect
nonelect10410283nonelect
praelect1247533praelect
preelects1356083pre_elects
preerect1259273pre_erect
prelect111013833_prelect
preselected1643963preselected
realest73322433re_alest
reblent9614253re_blent
recement12315653recement
recollect1345703recollect
redefeat1246313redefeat
redefects1543793redefects
redirect11147993redirect
redolent9411883redolent
reejects17336083re_ejects
reelected1238313re_elected
reeled74725533re_ele_d
reeler63822573re_ele_r
reelers73520273re_elers
reenact9413013re_enact
reerects10319923re_erects
refect114319333r__efect
refelt94521423refel__t
referent112813423referent
reflects13288873re_flects
reflet94024233re_fle_t
reglet73724233re_gle_t
reinfect1346483reinfect
reinject1745543reinject
reject154116283r__eject
relent64431853r__elent
relet54749823r__ele_t
relict83623903r__elict
reluct83916113r__eluct
remeet86325473reme_e_t
remelt85123123remel__t
reobject1953113reobject
repellent1148383repellent
rerepeat1047953rerepeat
resale64025543resale__
resales74724903resale_s
resealed92713973reseale_d
research1344553research
reseat64131493res__eat
resects94115593res__ects
resee54336333rese_e__
reseed74823293rese_e_d
reseeds84012333rese_eds
reseek103813133rese_e_k
reseeks11348623rese_eks
reseen64318413rese_e_n
resees63827483rese_e_s
reselecting1446023reselecting
resell64215203resel__l
reseller83412253reseller
resellers9299933resellers
resells73313203resel_ls
resent63833623res__ent
reset55051863res__e_t
resewed113011823resewe_d
resident9313753resident
resile64627673resile__
resiled84621983resile_d
resiles74026543resile_s
resilient9410113resilient
resmelt9411773res_melt
resojet14312823resoje_t
resole64624183resole__
resoled84119283resole_d
resoles73823653resole_s
resolvent1246583resolvent
respects1247703res_pects
respelt9312143res_pelt
resplice1237253resplice
resplit9310373respl_it
restless82713163restless
restrict10313633restrict
resubject2042313resubject
result6318223resul__t
resurrect1144883resurrect
revehent14239083revehent
reveled113917753revele_d
reveler104116343revele_r
revelers113414133revelers
revelment1448773revelment
reverent112615093reverent
selects91912143__selects

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621127.83018666.9
3Display Results1121120.0462434.8
 (SQL Overall)1786911128.28221575.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.