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

271 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
retreat731753(None) 
pretreat10311921pretreat
retread849001retread
retreats8311411retreats
entreat7315262entreat
estreat7314812estreat
hereat93527412he_reat
intreat7416302intreat
pretreats1146932pretreats
recheat12415932recheat
recreant10311282recreant
recreate10313602recreate
redream10107912redream
redreamt11127182redreamt
reerect92915882reerect
regreet83015952regreet
regret73723532regre_t
reheat94423942re_heat
repeat85127212re_peat
reread71715432re_read
rerent63832452re_rent
reseat64131492re_seat
reteam83214532ret_eam
retear63115482ret_ear
retest64028452ret_est
rethread1245352rethread
retract91318112retract
retral64419742retr_al
retreads937822retreads
retreated10312622retreated
retreater9310202retreater
retrial7615552retrial
retroact10410002retroact
treat56240352__treat
bearcat11611913bearcat
befret11315963befre_t
bereft114317303be_reft
beret74946363be_re_t
betray111511443betr_ay
cereal8315833ce_real
dearest83618673dearest
defeat103817163de_feat
derat65044083de_r_at
detect94217403det_ect
detent73624483det_ent
detest74122843det_est
detract101414633detract
egret63327313_egre_t
entreats839773entreats
entreaty1146173entreaty
erect74129333_e_rect
estreats839423estreats
ferret93021173ferre_t
gerent73223093ge_rent
great66034243__great
intreats8311543intreats
jetbead1742983jetbead
lethean1037093lethean
maltreat1048643maltreat
meerkat1346943meerkat
merest84725113me_rest
metre74821303metre__
metred95315143metre_d
metres85121563metre_s
metrist9317063metrist
mistreat10313113mistreat
nearest73415843nearest
nutmeat947953nutmeat
outeat62824533out_eat
outread82811093outread
overeat102620323overeat
overtreat1249373overtreat
perea75026443pe_rea_
pertest9317043pertest
petrel83111533petre_l
petrels9279373petrels
preerect1259273preerect
preheat12413893pre_heat
preterit10315843preterit
pretest9517633pret_est
pretext1639663pret_ext
pretreated1347623pretreated
pretrial10511983pretrial
rarest65725483r_arest
ratatat7412263ratatat
reagent8716603reagent
realest73322433realest
reared75930013reare_d
rearer64928913reare_r
rearers74323563rearers
rearrest8311603rearrest
reblent9614253reblent
rebred95816353rebre_d
rebreed104611073rebreed
recent83630853re_cent
recept103319073re_cept
recheats1339193recheats
reclean938523reclean
recoat84024273re_coat
recrate92621663recr_ate
recreants1146623recreants
recreated12412533recreated
recreates11313363recreates
recruit939773recruit
redbreast1243623redbreast
redcoat10410883redcoat
reddest9311953reddest
redear73515173re_dear
redefeat1246313redefeat
redhead1257053redhead
redirect11147993redirect
redraft11310573redraft
redraw10269853redr_aw
redreams1195953redreams
redress82511873redress
redrew10309503redre_w
redroot8312903redroot
reeject16349623reeject
reelect911515633reelect
reerects10319923reerects
reest54938093re__est
refect114319333re_fect
refelt94521423re_felt
referent112813423referent
reflect123913713reflect
reflet94024233refle_t
refloat10310833refloat
reforest1139963reforest
reformat1357653reformat
refract121311603refract
refresh1335453refresh
refront10313263refront
regear73512743re_gear
regent74127673re_gent
reglet73724233regle_t
regraft11310153regraft
regrant8317323regrant
regrate82618663regr_ate
regreen8309043regreen
regreets9287853regreets
regress82711453regress
regrets83212923regrets
regrew10388563regre_w
rehear93713223re_hear
reheats104513523re_heats
reiterate9412933reiterate
reject154116283re_ject
relent64431853re_lent
relet54749823re_le_t
remeet86325473re_meet
remelt85123123re_melt
remet74843723re_me_t
renest64529713re_nest
rennet64624853renne_t
reorient8613473reorient
repeal84718283re_peal
repeats94316053re_peats
repent84728873re_pent
replead10399003replead
repress92712683repress
reprint9318983reprint
request16311023request
reran57329103re_r_an
rereads81512293re_reads
rerents73319423re_rents
rerepeat1047953rerepeat
resat55139683re__sat
reseal64819643re_seal
reseats74319583re_seats
reseau64216213re_seau
resect84424703re_sect
resent63833623re_sent
reset55051863re_se_t
resmelt9411773resmelt
respeak1335933respeak
respect11412033respect
respelt9312143respelt
respread1135433respread
restress82511773restress
restrict10313633restrict
retag63618413ret__ag
retardant1046833retardant
retardate1047023retardate
retarget9312743retarget
retax124517973ret__ax
rete44944133ret_e__
reteach1237413ret_each
reteams9339563ret_eams
retears72814923ret_ears
retell63813643ret_ell
retem74221953ret_e_m
retems83914573ret_ems
retene69224273ret_ene
retests73813853ret_ests
rethreads1344483rethreads
retia55326113ret_ia_
retial64724993ret_ial
reticent10313293reticent
retie55735303retie__
retied75924983retie_d
reties65436193retie_s
retina65023383retina_
retinae75517333retinae
retinal75318353retinal
retinas74819353retinas
retint65633443ret_int
retirant8313593retirant
retire64927013retire__
retired84620143retire_d
retiree75019083retire_e
retirees84611653retirees
retirer74715013retire_r
retirers84311533retirers
retires74726213retire_s
retore67630763retore__
retort66831143ret_ort
retotal739843retotal
retrace91417343retrace
retrack131310723retrack
retracts101111313retracts
retrain7615423retrain
retreaded1137053retreaded
retreatant1054943retreatant
retreaters1047543retreaters
retreating111414773retreating
retrench1346283retrench
retrials8510823retrials
retried84419153retried
retries74129073retries
retrieval1243283retrieval
retrieve1175693retrieve
retrim83514883retr_im
retrims93612373retrims
retro55020953retr__o
retroacts1146283retroacts
retrofit1148303retrofit
retros63820193retr_os
retry84718083retr__y
retted74826313rette_d
retwist1039483retwist
reveal94115053re_veal
reverent112615093reverent
revert93529113re_vert
revest94623603re_vest
revet84938843re_ve_t
rewear93011993re_wear
rewet85135153re_we_t
rewrap11127533rewr_ap
rewrapt12138113rewrapt
searest73322023searest
secret8325063secre_t
serest64831613se_rest
streak104613623_streak
stream84717283_stream
street64125773_street
teat45963633__t_eat
terret63425623terre_t
tetra53417953tetr_a_
tetrad73612053tetr_ad
tetras63017623tetr_as
thereat104315243thereat
threat95020463_threat
tread64821703__tread
treats64821693__treats
treaty94414353__treaty
tret46653533__tre_t
untread857413untread
ureteral856233ureteral
veteran1039353veteran
wettest10239363wettest
whereat134311923whereat

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 Filter1786911340270.1431249587.4
2DLD Change Limit1340272716.57620381.2
3Display Results2712710.0932914.0
 (SQL Overall)1786912716.81226231.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.