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

451 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
recoil8401672(None) 
reboil83814681reboil
recoal84117971recoal
recoils93814871recoils
recoin84320291recoin
reoil55321181re_oil
coil66439652__coil
preboil1148952preboil
precool1139012precool
reboils94111722reboils
recall83815722recall
recit75235102rec_it
recoals94214622recoals
recoat84024272recoat
recock145112722recock
recode93618712recode
recoiled113613212recoiled
recoiler103210492recoiler
recoins94019242recoins
recomb1238872recomb
recon75624242reco_n
recons84922992recons
recook125513922recook
recopy1339042recopy
record96117432record
recork126315492recork
recoup10810372recoup
rectal84418132rectal
recti73619622recti_
rejoin134012242rejoin
remail85017122remail
renail65020762renail
reoils64516872re_oils
repoll8410792repoll
reroll6412682reroll
resail64418732resail
retail65522072retail
retool63914482retool
roil46235292r__oil
trefoil1066062trefoil
uncoil8811852uncoil
upcoil10126192upcoil
aboil72217543_aboil
aecia73819283aec_ia
aecial84817313aecial
archil11611573archil
assoil688543assoil
become123312593become
befool1137713befool
befoul1137253befoul
behowl1445533behowl
bewail1189583bewail
bezil163812883be_zil
boil66335183__boil
breccia1344453breccia
breccial1444693breccial
brocoli1146353brocoli
broil74918223_broil
ceboid11310653ceboid
cecal94619113cec_al
ceil65725063__ceil
ceorl7410923ce_orl
coal66939253__coal
coif96337913__coif
coils75030083__coils
coin66645353__coin
coir66327243__coir
col59360353__co_l
cool66940493__cool
cowl97530813__cowl
cresol8310213creso_l
cricoid1239243cricoid
dacoit9415453dacoit
deasil71110983deasil
decal85523233dec_al
deceit93018213deceit
decile94619213dec_ile
deckel134911043deckel
deco76125973deco__
decoct11313783decoct
decode104414743decode
decor84717573deco_r
decors94017773decors
decos85522123deco_s
decoy115716313deco_y
decoys123911283decoys
decrial10310323decrial
deil56231623de__il
dentil74017883dentil
derail74218813derail
despoil1046523despoil
detail74516433detail
devil94714733de_vil
devoid1189363devoid
devoir1076033devoir
dewool1047403dewool
echoic1339043_echoic
eloin55923203_eloin
email74715103_email
enol45823823_eno_l
entoil6912493entoil
erectile1039513erectile
ericoid1049893ericoid
ervil8310303_ervil
etoile6312263_etoile
evil75318073_e_vil
fecal105119213fec_al
fecial114714623fecial
foil76433913__foil
fucoid1237893fucoid
gentil74115123gentil
geoid74215763ge_oid
gerbil938343gerbil
hectic132311523hectic
heil76328933he__il
hemoid12313513hemoid
heroic113516923heroic
heroin94420593heroin
jetfoil1742913jetfoil
jezail2234643jezail
keloid11812623keloid
ketol95414003keto_l
kevil12399863ke_vil
lectin82515013lectin
lentil64315393lentil
meloid9616003meloid
memoir1037213memoir
metol75917813meto_l
moil65534093__moil
mucoid1139783mucoid
nerol51017813nero_l
neroli61111153neroli
nevoid1098793nevoid
nicol71113293nico_l
noil46133243__noil
oil37452053___oil
orchil1158653orchil
orectic1138823orectic
pectic122913873pectic
pectin102615533pectin
pencil103712973pencil
pensil83013333pensil
percoid12312313percoid
peril75425953pe_ril
peyotl1146233peyotl
preboils1267293preboils
prechill1546193prechill
precis103416703prec_is
precocial1547503precocial
precode12311853precode
precoital1347273precoital
precook1577803precook
precools1237703precools
precoup1336123precoup
prevail1238243prevail
rachial122012173rachial
rachis114017653rachis
racial83419243racial
racily11715173rac_ily
racon75422143raco_n
racons84319343racons
racoon83814473racoon
rail46147763r__ail
ramtil8311033ramtil
readily11711403readily
reagin74915533reagin
real45750293re__al
realia6314593realia
reavail1035643reavail
rebait8320403rebait
rebel73421293re_bel
rebid85121363re_bid
rebill84713253rebill
rebody1238153rebody
reboiled11349393reboiled
rebook125213203rebook
reboot84119333reboot
rebop9313283rebo_p
rebops10311433rebops
rebore86625653rebore
reborn810016963reborn
rebozo1737323rebozo
rebuild1036293rebuild
rebuilt939973rebuilt
rec55645463rec___
recalls92613623recalls
recane83022873recane
recant83228683recant
recap95718023rec_ap
recaps103615733recaps
recast83422773recast
recce9514563rec_ce
recces10614913recces
recede95515533recede
receipt1159253receipt
receive1239733receive
recent83630853recent
recept103319073recept
recess8314263recess
rechew14310213rechew
rechose121312043rechose
recipe103414893recipe
recital9412163recital
recite83625113recite
recits83621353recits
reck106130563rec__k
recked134821803recked
recking144319923recking
reckon123010543reckon
reckons13269653reckons
recks115625133rec_ks
reclad9311873reclad
reclaim1137753reclaim
recline94020493recline
recoaled113111783recoaled
recoats92616643recoats
recocks154711463recocks
recoded113115033recoded
recodes102918633recodes
recodify1743943recodify
recoding122213853recoding
recoilers11318153recoilers
recoiling121412413recoiling
recoined113614423recoined
recolor978693recolor
recombs1336753recombs
recommit1445553recommit
recompile1545223recompile
reconcile1347843reconcile
recooks134711233recooks
recopied1339843recopied
recopies12313733recopies
records105213923records
recorks134813023recorks
recount9315173recount
recoupe11109933recoupe
recouple12107123recouple
recoups1188843recoups
recover124312623recover
recross989833recross
recrown12257573recrown
recruit939773recruit
recs65734183rec__s
recta74220263rec_ta
rectify1536453rectify
recto74520803rec_to
rector84019753rector
rectorial11119893rectorial
rectors93520523rectors
rectory123512733rectory
rectos85718783rectos
rectrix1645363rectrix
rectum103411283rectum
rectus83314633rectus
recur74116843rec_ur
recurs83315803recurs
recusal968673recusal
recuse85519163recuse
recut74729243rec_ut
recuts83817373recuts
recycle1445343recycle
redcoat10410883redcoat
redfin10310223redfin
redia65524483re_dia
redial74923113redial
redid74922393re_did
redip87816963re_dip
redo56029363redo__
redock134311543redock
redoes74623773redoes
redoing93516733redoing
redon65424883redo_n
redone74820053redone
redons75222183redons
redos65126763redo_s
redout71820253redout
redowa1038453redowa
redox134714233redo_x
redpoll1045043redpoll
redrill857893redrill
redtail858713redtail
reedily1179613reedily
reedit7617223reedit
reel45240533re__el
reemit8717223reemit
refall94314393refall
refeel93913243refeel
refel84920813re_fel
refell94214443refell
refile95122373re_file
refill94514053refill
refilm114311403re_film
refit84230063re_fit
refix155212483re_fix
refold103812113refold
reform11312713reform
refuel93912623refuel
regain74517763regain
regal65023793re_gal
regild8149773re_gild
regilt71217493re_gilt
region74614903region
regnal74812933regnal
regosol844883regosol
reguli738143reguli
reheel93610823reheel
rei35647253re__i_
reif76937653re__if
rein46040893re__in
reis45343233re__is
rejig133810123re_jig
rejoice16287453rejoice
rejoins143111383rejoins
reknit10312533reknit
relaid75518443relaid
relic74623363re_lic
relit55340683re_lit
reload7413893reload
reloan6415693reloan
relock124713523relock
relook104813743relook
remails94714563remails
remain85919863remain
remit75737223re_mit
remix145916553re_mix
remodel1038093remodel
remold93412973remold
remora8414593remora
remorid10311863remorid
remote84222603remote
removal1236733removal
remove116115573remove
renails74917263renails
renal55929503re_nal
renig64518913re_nig
renin54830033re_nin
rennin63914033rennin
renown9369983renown
rental63922023rental
renvoi945863renvoi_
renvois1036503renvois
reoiled84316853re_oiled
repaid94716323repaid
repair84011463repair
repeal84718283repeal
repel74921403re_pel
repin75324703re_pin
repo66027543repo__
repolls939053repolls
report85326023report
repos74725793repo_s
reposal939113reposal
repose84121413repose
reposit9315863reposit
repot75132623repo_t
repots85621003repots
repour8310993repour
reptile93914083reptile
requin15310713requin
rerig64018483re_rig
rerolls739943rerolls
reroof9315003reroof
rerose63320843rerose
resaid74517083resaid
resails74616743resails
reschool1344133reschool
rescore95616203rescore
reseal64819643reseal
resell64215203resell
reship11310673reship
resid64124093re_sid
resile64627673re_sile
resin54131053re_sin
resit54241043re_sit
resoak10311093resoak
resod64720053reso_d
resods74116303resods
resold73915363resold
resole64624183resole
resorb84914353resorb
resort65728623resort
resow88217243reso_w
resown94112923resown
resows93915353resows
respool937643respool
retails74718973retails
retain64523283retain
retell63813643retell
retia55326113re_tia
retial64724993retial
retie55735303re_tie
retile65929673re_tile
retold73013753retold
retook104313443retook
retools73411023retools
retore67630773retore
retorn610923433retorn
retort66831153retort
retotal739843retotal
retral64419743retral
retrial7615553retrial
retrim83514883retrim
reveal94115053reveal
revel84423163re_vel
revile94921613re_vile
revoice12319183revoice
revoke135216243revoke
revolt9316223revolt
revote94917453revote
rewin85623963re_win
rewoke1339521223rewoke
rewon86920583rewo_n
reword106321413reword
rewore938030163rewore
rework136619793rework
reworn98122203reworn
rewove126420083rewove
rezone153814783rezone
ricin74620213ric_in
rictal83113183rictal
ridgil8316823ridgil
rococo1036813rococo
roils54826793r__oils
roily86121113r__oily
roll46331653r__oll
rotl45029683r__otl
scowl1012012973_scowl
seconal9310073seconal
second9411153second
sectile9311973sectile
serail64222673serail
soil46138833__soil
spoil75818653_spoil
techie11511723techie
techily1537123techily
tectal83713253tectal
teloi54217383teloi_
tenail64516113tenail
toil46536283__toil
trefoils1145303trefoils
trenail7410813trenail
trochil1258713trochil
uncoils979533uncoils
uncool8610113uncool
upboil1096453upboil
upcoils1184933upcoils
uracil8311543urac_il
veil75523593ve__il
vexil1538963ve_xil
weevil1295433weevil
zechin20137703zechin

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 Filter1786911127160.390458182.1
2DLD Change Limit1127164515.87619182.4
3Display Results4514510.1403221.4
 (SQL Overall)1786914516.40627894.3
 
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.