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

239 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
reerect9291588(None) 
preerect1259271preerect
reeject16349621reeject
reelect911515631reelect
reerects10319921reerects
coerect11913352coerect
erect74129332__erect
preelect1249642preelect
preerects1345412preerects
redefect1446052redefect
redirect11147992redirect
reejects17336082reejects
reelects103110882reelects
reenact9413002reenact
reerected1238612reerected
refect114319332r_efect
referent112813422referent
reflect123913712reflect
refract121311602refract
regreet83015952regreet
regret73723532regre_t
reject154116282r_eject
rerent63832452r_erent
resect84424702r_esect
reselect1059942reselect
respect11412032respect
retract91318112retract
retreat7317532retreat
reverent112615092reverent
beeriest104013403beeriest
befret11315963befre_t
bereft114317303_bereft
beret74946363_bere_t
coerects1258543coerects
correct11513983correct
dearest83618673dearest
deepest10310443deepest
defect124816173_defect
deferent122712873deferent
deflect13399973deflect
deject164512843_deject
deselect1147523deselect
detect94217403_detect
detract101414633detract
direct93817333_direct
eeriest73620673_eeriest
effect1437443_effect
egret63327313_egre_t
eject145016043__eject
elect74327033__elect
erects84116183__erects
eruct74022353__eruct
expect1758903_expect
exsect1558503_exsect
ferret93021173ferre_t
gerent73223093_gerent
greenest9312623greenest
hereat93527413_hereat
jeered143912793jeere_d
jeerer13389933jeere_r
jeerers14328923jeerers
keenest11410963keenest
leered73816223leere_d
leeriest83112883leeriest
leveret103014003levere_t
meekest1336893meekest
meerkat1346943meerkat
merest84725113_merest
nearest73415843nearest
neglect1047363neglect
overact12315043overact
overeat102620323overeat
peered93819483peere_d
peeress939503peeress
perfect141010833perfect
porrect1159743porrect
praefect1544773praefect
praelect1247533praelect
preelects1356083preelects
preenact12410183preenact
preerected1545573preerected
prefect141011073prefect
prelect111013833prelect
preselect1346983preselect
pretreat10311923pretreat
queerest1746273queerest
rarest65725483r_arest
react74634333r_e_act
reagent8716603reagent
realest73322433realest
reared75930013reare_d
rearer64928913reare_r
rearers74323563rearers
rearrest8311603rearrest
rebec94416543r_ebec_
rebeck14419913r_ebeck
rebecs103913673r_ebecs
reblent9614253reblent
rebred95816353rebre_d
rebreed104611073rebreed
recement12315653recement
recent83630853r_ecent
recept103319073r_ecept
recheat12415933recheat
recheck1835613recheck
recreant10311283recreant
recreate10313603recreate
recruit939773recruit
redact9419043r_edact
reddest9311953reddest
redefeat1246313redefeat
redefects1543793redefects
redirects12125103redirects
redneck1445113redneck
redraft11310573redraft
redream10107913redream
redreamt11127183redreamt
redress82511873redress
redrew10309503redre_w
redroot8312903redroot
reeded84022563reede_d
reediest92815423reediest
reedit7617223ree_dit
reefed103816583reefe_d
reefer93314363reefe_r
reefers103312593reefers
reefiest112811483reefiest
reejected1955093reejected
reeked113717643reeke_d
reeker103715593reeke_r
reekers113613143reekers
reekiest122711313reekiest
reelected1238313reelected
reeled74725533reele_d
reeler63822573reele_r
reelers73520273reelers
reemit8717223ree_mit
reenacts1036993reenacts
reerecting1339973reerecting
reest54938093r_e_est
reeve84121323reeve__
reeved104118713reeve_d
reeves94721493reeve_s
reexecute1862723reexecute
refects124012743r_efects
refelt94521423r_efelt
referee101615753refere_e
refereed12149693refereed
referees111310413referees
reference14810093reference
referents12259643referents
reflects13288873reflects
reflet94024233refle_t
reforest1139963reforest
refracts13137383refracts
refresh1335453refresh
refront10313263refront
regent74127673r_egent
reglet73724233regle_t
regraft11310153regraft
regrant8317323regrant
regreen8309043regreen
regreets9287853regreets
regress82711453regress
regrets83212923regrets
regrew10388563regre_w
reheat94423943r_eheat
reinfect1346483reinfect
reinject1745543reinject
rejects163910693r_ejects
relent64431853r_elent
relet54749823r_ele_t
relict83623903r_elict
reluct83916113r_eluct
remeet86325473r_emeet
remelt85123123r_emelt
remet74843723r_eme_t
renest64529713r_enest
rennet64624853renne_t
reobject1953113reobject
reorient8613473reorient
repeat85127213r_epeat
repent84728873r_epent
repress92712683repress
reprice113212833reprice
reprint9318983reprint
request16311023request
rerack122513163r_erack
reread71715433r_eread
rerents73319423r_erents
rerepeat1047953rerepeat
reseat64131493r_eseat
resects94115593r_esects
reselects1156413reselects
resent63833623r_esent
reset55051863r_ese_t
resmelt9411773resmelt
respects1247703respects
respelt9312143respelt
restrict10313633restrict
resurrect1144883resurrect
retest64028453r_etest
retrace91417343retrace
retrack131310723retrack
retracts101111313retracts
retread849003retread
retreats8311413retreats
retrench1346283retrench
retroact10410003retroact
revehent14239083revehent
revere94621253revere__
revered112819333revere_d
reverence14710163reverence
reverend12288853reverend
reverer103815833revere_r
reverers113113153reverers
reveres103621343revere_s
revert93529113r_evert
revest94623603r_evest
revet84938843r_eve_t
rewet85135153r_ewe_t
rewrapt12138113rewrapt
searest73322023searest
secrecy1444743secrecy
secret8325063secre_t
seeress7311573seeress
select82621173_select
semierect1355383semierect
serest64831613_serest
severest11310323severest
sheerest11310083sheerest
suberect12410873suberect
tenrec837513tenrec_
tenrecs936033tenrecs
tercet83624913_tercet
terret63425623terre_t
thereat104315243thereat
veered103612743veere_d
whereat134311923whereat

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272397.06318975.9
3Display Results2392390.0932569.9
 (SQL Overall)1786912397.31224438.0
 
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.