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 “reselects” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

84 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
reselects115641(None) 
deselects1244491deselects
preselects1464361preselects
reelects103110881re_elects
reselect1059941reselect_
deselect1147522deselect_
preelects1356082pre_elects
preselect1346982preselect_
redefects1543792redefects
reejects17336082re_ejects
reelect911515632re_elect_
reerects10319922re_erects
reflects13288872re_flects
resects94115592res__ects
reselected1345632reselected
respects1247702res_pects
selects91912142__selects
basilects1342973basilects
deflects14336733de_flects
derelicts12154183derelicts
deselected1444083deselected
elects83315003___elects
eyelets1057523_eyele_ts
neglects1144383ne_glects
praelects1354353praelects
preelect1249643pre_elect_
preerects1345413pre_erects
prelects1299723_prelects
preselected1643963preselected
recements13312283recements
recollects1443683recollects
redefeats1344203redefeats
redefect1446053redefect_
redirects12125103redirects
reeject16349623re_eject_
reelected1238313re_elected
reelers73520273re_ele_rs
reenacts1036993re_enacts
reerect92915883re_erect_
refects124012743r__efects
referents12259643referents
reflect123913713re_flect_
reflets103513153re_fle_ts
reglets83512983re_gle_ts
reinfects1444723reinfects
reinjects1844023reinjects
rejects163910693r__ejects
relents74018503r__elents
relets64025673r__ele_ts
relicts94414593r__elicts
relucts9369673r__elucts
remeets93712413reme_e_ts
remelts93511493remel__ts
reobjects2062003reobjects
repellents1245143repellents
rerepeats1145263rerepeats
resales74724903resale__s
reseats74319583res__eats
resect84424703res__ect_
reseeds84012333rese_e_ds
reseeks11348623rese_e_ks
resees63827483rese_e__s
reselecting1446023reselecting
resellers9299903resellers
resells73313203resel__ls
resents74221223res__ents
resets65427613res__e_ts
residents1038423residents
resiles74026543resile__s
resmelts1046143res_melts
resojets1535343resoje_ts
resoles73823653resole__s
resolvents1344343resolvents
respect11412033res_pect_
resplices1336623resplices
resplits1037723respl_its
restless82713163restle_ss
restricts1138823restricts
resubjects2151593resubjects
results739833resul__ts
resurrects1242823resurrects
revelers113414133revele_rs
revelments1546863revelments
select82621173__select_

Search took 7 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 Limit148641846.47022973.9
3Display Results84840.0302800.0
 (SQL Overall)178691846.92025822.4
 
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.