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

129 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
reejects1733608(None) 
reeject16349621reeject_
reelects103110881reelects
reerects10319921reerects
rejects163910691r_ejects
dejects17389222_dejects
ejects15409952__ejects
preelects1356082preelects
preerects1345412preerects
redefects1543792redefects
reejected1955092reejected
reelect911515632reelect_
reenacts1036992reenacts
reerect92915882reerect_
refects124012742r_efects
reflects13288872reflects
reinjects1844022reinjects
reject154116282r_eject_
reobjects2062002reobjects
resects94115592r_esects
reselects1156412reselects
respects1247702respects
coerects1258543coerects
defects134511523_defects
deflects14336733deflects
deject164512843_deject_
dejecta17376363_dejecta
deselects1244493deselects
detects104011093_detects
disjects18275923disjects
effects1535283_effects
eject145016043__eject_
ejecta15337393__ejecta
elects83315003__elects
erects84116183__erects
expects1866883_expects
exsects1655573_exsects
injects16257453_injects
neglects1144383neglects
objects18123693_objects
perfects15107353perfects
praefects1642873praefects
praelects1354353praelects
preelect1249643preelect_
preenacts1345843preenacts
preerect1259273preerect_
prefects1598133prefects
prelects1299723prelects
preselects1464363preselects
projects1936413projects
ramjets1635163ramje_ts
reacts83616603r_e_acts
reagents959623reagents
rebecks15288013r_ebecks
rebecs103913673r_ebec_s
recements13312283recements
recepts113010263r_ecepts
recheats1339193recheats
rechecks1944553rechecks
redacts10510943r_edacts
redefeats1344203redefeats
redefect1446053redefect_
redirects12125103redirects
rednecks1544013rednecks
reedits8511743ree_dits
reefers103312593reefe_rs
reejecting2045813reejecting
reekers113613143reeke_rs
reelected1238313reelected
reelers73520273reele_rs
reemits9611303ree_mits
reenact9413013reenact_
reerected1238613reerected
reests64618893r_e_ests
reeves94721493reeve__s
reexecute1862723reexecute
reexecutes1962623reexecutes
refect114319333r_efect_
referents12259643referents
reflect123913713reflect_
reflets103513153refle_ts
refracts13137383refracts
regents83416543r_egents
reglets83512983regle_ts
regreets9287853regreets
regrets83212923regre_ts
reheats104513523r_eheats
reinfects1444723reinfects
reinject1745543reinject_
rejected182710113r_ejected
rejectee17289623r_ejectee
rejectees18235423r_ejectees
rejecter17258943r_ejecter
rejecters18257543r_ejecters
rejector17237723r_ejector
rejectors18247613r_ejectors
relents74018503r_elents
relets64025673r_ele_ts
relicts94414593r_elicts
relucts9369673r_elucts
remeets93712413r_emeets
remelts93511493r_emelts
renests74014213r_enests
rennets75212633renne_ts
reobject1953113reobject_
repeats94316053r_epeats
repents93717623r_epents
requests1735743requests
rerents73319423r_erents
rerepeats1145263rerepeats
reseats74319583r_eseats
resect84424703r_esect_
reselect1059943reselect_
resents74221223r_esents
resets65427613r_ese_ts
resmelts1046143resmelts
resojets1535343resoje_ts
respect11412033respect_
resubjects2151593resubjects
retests73813853r_etests
retracts101111313retracts
retreats8311413retreats
reverts104715043r_everts
revests104413733r_evests
revets94022173r_eve_ts
rewets94617213r_ewe_ts
selects91912143_selects
subjects19226533subjects
trajects1744533trajects

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621297.20320291.8
3Display Results1291290.0462804.3
 (SQL Overall)1786911297.66923300.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.