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

545 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
recoat8402427(None) 
recoal84117971recoal
recoats92616641recoats
redcoat10410881redcoat
coat67558352__coat
decoct11313782decoct
eclat7523602_eclat
peacoat11412912peacoat
reboant9315092reboant
reboot84119332reboot
recant83228682recant
recap95718022rec_ap
recast83422772recast
recent83630852recent
recept103319072recept
rechart12314332rechart
recheat12415932recheat
recit75235102rec_it
reclad9311872reclad
recoals94214622recoals
recoated113416782recoated
recock145112722recock
recode93618712recode
recoil84016722recoil
recoin84320292recoin
recomb1238872recomb
recon75624242reco_n
recons84922992recons
recook125513922recook
recopy1339042recopy
record96117432record
recork126315492recork
recount9315172recount
recoup10810372recoup
recrate92621662recrate
recta74220262recta_
rectal84418132rectal
recut74729242rec_ut
redcoats1147122redcoats
redout71820252redout
refloat10310832refloat
reheat94423942reheat
reload7413892reload
reloan6415692reloan
repeat85127212repeat
report85326022report
repot75132622repo_t
resat55139682re_sat
reseat64131492reseat
resoak10311092resoak
resort65728622resort
retort66831152retort
revolt9316222revolt
accost101112263accost
aecia73819283aecia_
aecial84817313aecial
aerobat9514473aerobat
aerosat7417183aerosat
afloat9315153afloat
areca75618633arec_a_
arecas84817443arec_as
ascot76522513asco_t
bareboat1249943bareboat
beat66168303be__at
becap114315053bec_ap
becket144619883becket
becloak1545043becloak
become123312593become
begat86629723be_gat
begot84625953bego_t
bemoan10310253bemoan
besot76429713beso_t
bezoar1736913bezoar
bloat75229923_bloat
bluecoat1244493bluecoat
boat66360313__boat
brecham1646833brecham
brechan1437223brechan
cat58282343__c_at
ceca84820783cec_a_
cecal94619113cec_al
chat95546133__chat
coact96130583__coact
coal66939253__coal
coapt96131533__coapt
coast75236273__coast
coati75624643__coati
coats75635003__coats
coax136922983__coax
cocoa98517883cocoa_
cocoas104915743cocoas
cocomat13413623cocomat
coft97939683__coft
colt67158243__colt
coot67860383__coot
cost68057943__cost
cot510483223__co_t
dacoit9415453dacoit
decaf114919443dec_af
decal85523233dec_al
decant93524223decant
decay114718483dec_ay
deceit93018213deceit
decent94023703decent
declaw1266703declaw
deco76125973deco__
decocts1237833decocts
decode104414743decode
decor84717573deco_r
decorate11315193decorate
decors94017773decors
decos85522123deco_s
decoy115716313deco_y
decoys123911283decoys
defat95426693de_fat
defeat103817163defeat
defoam1238563defoam
dehort104618103dehort
deport94922393deport
depot85727923depo_t
derat65044083de_rat
devout10712993devout
dicot85429093dico_t
doat56947673__doat
ducat86225903duc_at
eat36989053_e__at
echt95722903_ec_ht
eclats8313033_eclats
erect74129333erec__t
ergot65422893ergo_t
escort84616483escort
escot75320083esco_t
expat14313813_expat
feat76458223fe__at
fecal105119213fec_al
fecial114714623fecial
fireboat1349093fireboat
float85928573_float
gemot84024233gemo_t
genoa64315823genoa_
genoas74013623genoas
gloat65427683_gloat
goat56250833__goat
great66034243gre__at
greatcoat1253353greatcoat
groat65531973_groat
heat77061423he__at
helot85332683helo_t
hepcat13611823hepcat
hereat93527413hereat
iceboat1147163iceboat
meat66359603me__at
mecca1139933mecca_
meccas1239493meccas
moat66352033__moat
neat46356783ne__at
nectar838853nectar
oat39888263___oat
overcoat13312103overcoat
peacoats1247833peacoats
peat65967933pe__at
pecan91919033pec_an
peccant13311733peccant
pechan13511543pechan
pectate112214693pectate
pelota8612833pelota
picot95031013pico_t
precast11314853precast
precent113520263precent
precept133112513precept
precode12311853precode
precook1577803precook
precool1139013precool
precoup1336123precoup
precut102016533prec_ut
preheat12413893preheat
preload1049813preload
premolt11312073premolt
presoak1348453presoak
presort95219543presort
rabat72832223r_abat
rachet115028973rachet
racial83419243racial
racist82822793racist
racket125229423racket
racon75422143raco_n
racons84319343racons
racoon83814473racoon
ragout7317183ragout
raincoat1046633raincoat
rat37892743r___at
react74634333re_act
reactant10311433reactant
read55942533re__ad
readapt1039743readapt
readopt10410843readopt
readout8615513readout
real45750293re__al
ream65841613re__am
reap65934743re__ap
rear45644553re__ar
reata54225393re__ata
reatas64021013reatas
rebait8320403rebait
rebar75420193re_bar
rebate84424113re_bate
rebato83714683re_bato
reboard10310763reboard
rebody1238153rebody
reboil83814683reboil
rebook125213203rebook
reboots93512093reboots
rebop9313283rebo_p
rebops10311433rebops
rebore86625653rebore
reborn810016963reborn
rebozo1737323rebozo
rebut75927383re_but
rec55645463rec___
recall83815723recall
recane83022873recane
recants93217093recants
recaps103615733recaps
recasts93413533recasts
recce9514563rec_ce
recces10614913recces
recede95515533recede
receipt1159253receipt
recepts113010263recepts
recess8314263recess
recharts1337663recharts
recheats1339193recheats
rechew14310213rechew
rechose121312043rechose
recipe103414893recipe
recital9412163recital
recite83625113recite
recits83621353recits
reck106130563rec__k
recked134821803recked
reckon123010543reckon
reckons13269653reckons
recks115625133rec_ks
reclads1049993reclads
reclaim1137753reclaim
reclame11411063reclame
reclasp1136643reclasp
reclean938523reclean
recoaled113111783recoaled
recoating121317463recoating
recocks154711463recocks
recoded113115033recoded
recodes102918633recodes
recoils93814873recoils
recoins94019243recoins
recolor978693recolor
recombs1336753recombs
recommit1445553recommit
recontact1347163recontact
recooks134711233recooks
records105213923records
recorks134813023recorks
recounts1038773recounts
recoupe11109933recoupe
recoups1188843recoups
recover124312623recover
recrated112918603recrated
recrates102420373recrates
recreant10311283recreant
recreate10313603recreate
recross989833recross
recrown12257573recrown
recruit939773recruit
recs65734183rec__s
recti73619623rec_ti
recto74520803rec_to
rector84019753rector
rectorate11411363rectorate
rectors93520523rectors
rectory123512733rectory
rectos85718783rectos
rectum103411283rectum
rectus83314633rectus
recur74116843rec_ur
recurs83315803recurs
recusal968673recusal
recusant1049463recusant
recuse85519163recuse
recuts83817373recuts
redact9419043redact
redan66125013re_dan
redate74124683re_date
redbait1039803redbait
redbay1238333redbay
redcap1158493redcap
redear73515173redear
redia65524483redia_
rediae74221993rediae
redial74923113redial
redias74523603redias
redipt94116743redipt
redo56029363redo__
redock134311543redock
redoes74623773redoes
redon65424883redo_n
redone74820053redone
redons75222183redons
redos65126763redo_s
redoubt10167843redoubt
redouts81411663redouts
redowa1038453redowa
redowas1138393redowas
redox134714233redo_x
redraft11310573redraft
redraw10269853redraw
redroot8312903redroot
reedit7617223reedit
reemit8717223reemit
reenact9413013reenact
reest54938093re_est
refect114319333refect
refelt94521423refelt
refit84230063re_fit
reflag1098083reflag
reflate103516263reflate
reflet94024233reflet
refloats1156913refloats
refold103812113refold
reform11312713reform
reformat1357653reformat
refract121311603refract
refront10313263refront
reft75141273re__ft
regal65023793re_gal
regear73512743regear
regent74127673regent
reggae858953reggae
regilt71217493regilt
reglet73724233reglet
regma84612333regma_
regmata1036193regmata
regna64614813regna_
regnal74812933regnal
regnant8312843regnant
regraft11310153regraft
regrant8317323regrant
regrate82618663regrate
regret73723533regret
rehab10312443re_hab
rehear93713223rehear
reheats104513523reheats
reject154116283reject
rejoin134012243rejoin
reknit10312533reknit
reknot10311733reknot
relate64033633re_late
relax124817803re_lax
relay84424673re_lay
relent64431853relent
relet54749823re_let
reliant7319243reliant
relict83623903relict
relist64628413relist
relit55340683re_lit
reloads8911313reloads
reloans7313133reloans
relocate10713533relocate
relock124713523relock
relook104813743relook
reluct83916113reluct
reman75730153re_man
remap95418103re_map
remate84428683re_mate
remeet86325473remeet
remelt85123123remelt
remet74843723re_met
remint85329983remint
remit75737223re_mit
remixt155014853remixt
remnant9312643remnant
remold93412973remold
remora8414593remora
remoras9314073remoras
remote84222603remote
remount9512283remount
removal1236733removal
remove116115573remove
renal55929503re_nal
renest64529713renest
rennet64624853rennet
renovate1138553renovate
renown9369983renown
rent46661243re__nt
rental63922023rental
reoil55321183re_oil
repast83520633repast
repay104818453re_pay
repeal84718283repeal
repeats94316053repeats
repent84728873repent
replan83215823replan
replant93318533replant
replate93420053replate
replay113412923replay
replot83818593replot
repo66027543repo__
repoll8410793repoll
reports94916213reports
repos74725793repo_s
reposal939113reposal
repose84121413repose
reposit9315863reposit
repots85621003repots
repour8310993repour
reptant92817073reptant
reran57329103re_ran
reread71715433reread
rerent63832453rerent
reroll6412683reroll
reroof9315003reroof
rerose63320843rerose
reroute7313963reroute
resaw84117253re_saw
resay85320543re_say
rescore95616203rescore
reseal64819643reseal
reseats74319583reseats
reseau64216213reseau
resect84424703resect
resent63833623resent
reset55051863re_set
reshoot102513893reshoot
reshot93519633reshot
resift94017723resift
resist64524533resist
resit54241043re_sit
reslate73520593reslate
resoaks1148973resoaks
resod64720053reso_d
resods74116303resods
resojet14312823resojet
resold73915363resold
resole64624183resole
resonant8410813resonant
resonate8513513resonate
resorb84914353resorb
resorts74817193resorts
resow88217243reso_w
resown94112923resown
resows93915353resows
respot83117633respot
rest46459843re__st
restart7320033restart
restate73824883restate
result6318223result
ret35982833re___t
retag63618413re_tag
retax124517973re_tax
reteam83214533reteam
retear63115483retear
retest64028453retest
retia55326113retia_
retial64724993retial
retint65633443retint
retold73013753retold
retook104313443retook
retool63914483retool
retore67630773retore
retorn610923433retorn
retorts76016513retorts
retotal739843retotal
retract91318113retract
retral64419743retral
retreat7317533retreat
retroact10410003retroact
reveal94115053reveal
revert93529113revert
revest94623603revest
revet84938843re_vet
revoke135216243revoke
revolts1038893revolts
revote94917453revote
rewan85623663re_wan
rewax155713923re_wax
rewear93012003rewear
rewet85135153re_wet
rewoke1339521223rewoke
rewon86920583rewo_n
reword106321413reword
rewore938030163rewore
rework136619793rework
reworn98122203reworn
rewove126420083rewove
rewrap11127533rewrap
rewrapt12138113rewrapt
rezone153814783rezone
ricotta955433ricotta
ricrac1037013ricrac
rictal83113183rictal
riot45947213r_io_t
ripost83615003ripost
road56332113r__oad
roam67132413r__oam
roan47234203r__oan
roar46328573r__oar
roast56230143r__oast
robot7325973robo_t
rochet115423003rochet
rocket125425283rocket
rococo1036813rococo
roost55730933r_oost
root45655923r__oot
rot37282953r__o_t
rota45834343r__ota
rout46153283r__out
rowboat1267983rowboat
rubout8313563rubout
runout6414873runout
ryot75528563r_yo_t
scat65848373_sc_at
scoot75729153_scoot
scot66242613_sco_t
scout75031453_scout
seacoast1047783seacoast
seat47575563se__at
secant84023293secant
seconal9310073seconal
second9411153second
secpar1037923secpar
secret8325063secret
sect67443623sec__t
setout64719463setout
shoat85633953_shoat
stoat57135953_stoat
surcoat9412923surcoat
teat45963633te__at
tecta74215523tecta_
tectal83713253tectal
throat94819753throat
topcoat1179313topcoat
treat56240353tre__at
tricot8317753trico_t
turncoat1044853turncoat
upcoast1165543upcoast
wecht13415443wec_ht

Search took 6 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.373479064.3
2DLD Change Limit1127165454.97022679.3
3Display Results5455450.1862930.1
 (SQL Overall)1786915455.52932318.9
 
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.