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

539 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
recoal8411797(None) 
recoals94214621recoals
recoat84024271recoat
recoil84016721recoil
rectal84418131rectal
aecial84817312aecial
cecal94619112cec_al
coal66939252__coal
decal85523232dec_al
fecal105119212fec_al
fecial114714622fecial
precool1139012precool
racial83419242racial
real45750292re__al
reboil83814682reboil
recall83815722recall
recap95718022rec_ap
recital9412162recital
reclad9311872reclad
recoaled113111782recoaled
recoats92616642recoats
recock145112722recock
recode93618712recode
recoils93814872recoils
recoin84320292recoin
recomb1238872recomb
recon75624242reco_n
recons84922992recons
recook125513922recook
recopy1339042recopy
record96117432record
recork126315492recork
recoup10810372recoup
recta74220262recta_
recusal968672recusal
redcoat10410882redcoat
redial74923112redial
regal65023792re_gal
regnal74812932regnal
reload7413892reload
reloan6415692reloan
removal1236732removal
renal55929502re_nal
rental63922022rental
reoil55321182re_oil
repeal84718282repeal
repoll8410792repoll
reposal939112reposal
reroll6412682reroll
reseal64819642reseal
resoak10311092resoak
retial64724992retial
retool63914482retool
retotal739842retotal
retral64419742retral
reveal94115052reveal
rictal83113182rictal
seconal9310072seconal
tectal83713252tectal
acetal84314903acetal
aecia73819283aecia_
aerial64625713aerial
anconal939423anconal
areal55928733are__al
areca75618633arec_a_
arecas84817443arec_as
areola6813673are_ola
becalm1239203bec_alm
becap114315053bec_ap
bechalk1845803bechalk
becloak1545043becloak
become123312593become
becrawl1444583becrawl
befool1137713befool
befoul1137253befoul
behowl1445533behowl
bemoan10310253bemoan
benzal1739643benzal
bezoar1736913bezoar
breccial1444693breccial
brecham1646833brecham
brechan1437223brechan
buccal1248243buccal
caecal103713733caec_al
ceca84820783cec_a_
cental84420963cental
ceorl7410923ce_orl
cercal10314123cercal
cereal8315833cereal
coala77521123__coala
coals76129603__coals
coaly105521593__coaly
coat67558353__coat
coax136922983__coax
coccal9310223coccal
cocoa98517883cocoa_
cocoas104915743cocoas
coil66439653__coil
col59360353__co_l
cola66541393__cola
comal95125133__comal
cool66940493__cool
copal95621783__copal
coral76033453__coral
cowl97530813__cowl
coxal146116673__coxal
credal9311673cre_dal
creedal1037093creedal
cresol8310213creso_l
crestal9312133crestal
crucial1157893crucial
deal56347413de__al
decadal1137243decadal
decaf114919443dec_af
decals93717713dec_als
decanal1038113decanal
decay114718483dec_ay
decimal1238083decimal
deckel134911043deckel
declaw1266703declaw
deco76125973deco__
decoct11313783decoct
decode104414743decode
decor84717573deco_r
decors94017773decors
decos85522123deco_s
decoy115716313deco_y
decoys123911283decoys
decrial10310323decrial
dedal75719023de_dal
defoam1238563defoam
denial74720513denial
dental74319173dental
deposal1037153deposal
dermal93614343dermal
dewool1047403dewool
ducal84816423duc_al
ductal938993ductal
eclat7523603_eclat
egal55119433_e_gal
enol45823823_eno_l
equal1449823_equal
facial113615633facial
faecal11359813faec_al
feal713940423fe__al
fecials123510333fecials
fecula113310053fecula
femoral1238723femoral
feral85424653fe_ral
ferial94621253ferial
festal94213563festal
fetal85623373fe_tal
fetial95716193fetial
feudal1037683feudal
foal76630923__foal
focal104917673foc_al
fractal1237623fractal
genial74917613genial
genoa64315823genoa_
genoas74013623genoas
goal55829303__goal
gremial1039153gremial
heal75645693he__al
hemal104419803he_mal
herbal112513493herbal
jacal14313703jac_al
jackal1937613jackal
ketol95414003keto_l
keypal1534893keypal
leal46043273le__al
legal65715943le_gal
lethal939803lethal
local74820273loc_al
meal65643173me__al
meatal84114733meatal
mecca1139933mecca_
meccas1239493meccas
medal86221333me_dal
medial93819863medial
menial84223033menial
mensal84615663mensal
mental84521603mental
mescal104113493mescal
mesial84818083mesial
metal75427383me_tal
metol75917813meto_l
mezcal19367853mezcal
mucosal11155843mucosal
nectar838853nectar
nerol51017813nero_l
neural6311993neural
nicol71113293nico_l
nuchal11218873nuchal
octal71214723_octal
peacoat11412913peacoat
peal68648103pe__al
pecan91919033pec_an
pechan13511543pechan
pectoral121210503pectoral
pedal86022503pe_dal
pedocal1237893pedocal
penal75228373pe_nal
penial84120893penial
peroral9314793peroral
petal76526893pe_tal
peyotl1146233peyotl
pical95524373pic_al
preanal9310713preanal
preboil1148953preboil
precaval1544723precaval
precocial1547503precocial
precode12311853precode
precoital1347273precoital
precook1577803precook
precools1237703precools
precoup1336123precoup
predial103815413predial
preload1049813preload
premeal11310523premeal
premoral1249713premoral
preoral9312673preoral
presoak1348453presoak
rachial122012173rachial
racon75422143raco_n
racons84319343racons
racoon83814473racoon
radial74020393radial
ramal74622243r_amal
rascal8511123rascal
ratal55025113r_atal
read55942533re__ad
realm75621623re__alm
reals55038653re__als
ream65841613re__am
reap65934743re__ap
rear45644553re__ar
reata54225393reata_
reatas64021013reatas
reavail1035643reavail
rebar75420193re_bar
rebel73421293re_bel
rebill84713253rebill
reboant9315093reboant
reboard10310763reboard
rebody1238153rebody
reboils94111723reboils
rebook125213203rebook
reboot84119333reboot
rebop9313283rebo_p
rebops10311433rebops
rebore86625653rebore
reborn810016963reborn
rebozo1737323rebozo
rec55645463rec___
recalls92613623recalls
recane83022873recane
recant83228683recant
recaps103615733recaps
recast83422773recast
recce9514563rec_ce
recces10614913recces
recede95515533recede
recent83630853recent
recept103319073recept
recess8314263recess
rechart12314333rechart
recheat12415933recheat
rechew14310213rechew
rechose121312043rechose
recipe103414893recipe
recit75235103rec_it
recitals1039763recitals
recite83625113recite
recits83621353recits
reck106130563rec__k
recked134821803recked
reckon123010543reckon
reckons13269653reckons
recks115625133rec_ks
reclads1049993reclads
reclaim1137753reclaim
reclame11411063reclame
reclasp1136643reclasp
reclean938523reclean
recoaling121312453recoaling
recoated113416783recoated
recocks154711463recocks
recoded113115033recoded
recodes102918633recodes
recoiled113613213recoiled
recoiler103210493recoiler
recoins94019243recoins
recolor978693recolor
recombs1336753recombs
recooks134711233recooks
records105213923records
recorks134813023recorks
recount9315173recount
recountal1144193recountal
recoupe11109933recoupe
recouple12107123recouple
recoups1188843recoups
recover124312623recover
recrate92621663recrate
recross989833recross
recrown12257573recrown
recs65734183rec__s
rectally1339713rectally
recti73619623rec_ti
recto74520803rec_to
rector84019753rector
rectorial11119893rectorial
rectors93520523rectors
rectory123512733rectory
rectos85718783rectos
rectum103411283rectum
rectus83314633rectus
recur74116843rec_ur
recurs83315803recurs
recusals1056393recusals
recuse85519163recuse
recut74729243rec_ut
recuts83817373recuts
recycle1445343recycle
redan66125013re_dan
redbay1238333redbay
redcap1158493redcap
redcoats1147123redcoats
redear73515173redear
redia65524483redia_
rediae74221993rediae
redials84416883redials
redias74523603redias
redo56029363redo__
redock134311543redock
redoes74623773redoes
redon65424883redo_n
redone74820053redone
redons75222183redons
redos65126763redo_s
redout71820253redout
redowa1038453redowa
redowas1138393redowas
redox134714233redo_x
redpoll1045043redpoll
redraw10269853redraw
redtail858713redtail
reel45240533re__el
refall94314393refall
refeel93913243refeel
refel84920813re_fel
refell94214443refell
refill94514053refill
reflag1098083reflag
refloat10310833refloat
refold103812113refold
reform11312713reform
refuel93912623refuel
refusal1056893refusal
refutal1046943refutal
regale74821453re_gale
regear73512743regear
reggae858953reggae
reginal84814293reginal
regional9438783regional
regma84612333regma_
regna64614813regna_
regosol844883regosol
rehab10312443re_hab
rehear93713223rehear
reheat94423943reheat
reheel93610823reheel
rejoin134012243rejoin
relax124817803re_lax
relay84424673re_lay
reloads8911313reloads
reloans7313133reloans
relock124713523relock
relook104813743relook
remail85017123remail
reman75730153re_man
remap95418103re_map
remodel1038093remodel
remold93412973remold
remora8414593remora
remoras9314073remoras
remote84222603remote
removals1345643removals
remove116115573remove
renail65020763renail
renewal1038703renewal
renown9369983renown
rentals74017473rentals
reoils64516873re_oils
repay104818453re_pay
repeals94014523repeals
repeat85127213repeat
repel74921403re_pel
replan83215823replan
replay113412923replay
repo66027543repo__
repolls939053repolls
report85326023report
repos74725793repo_s
reposals1037403reposals
repose84121413repose
repot75132623repo_t
repots85621003repots
repour8310993repour
reproval1355773reproval
reran57329103re_ran
reread71715433reread
rerolls739943rerolls
reroof9315003reroof
rerose63320843rerose
resail64418733resail
resale64025543re_sale
resat55139683re_sat
resaw84117253re_saw
resay85320543re_say
rescale93215473rescale
reschool1344133reschool
rescore95616203rescore
reseals73917663reseals
reseat64131493reseat
reseau64216213reseau
resell64215203resell
resoaks1148973resoaks
resod64720053reso_d
resods74116303resods
resold73915363resold
resole64624183resole
resorb84914353resorb
resort65728623resort
resow88217243reso_w
resown94112923resown
resows93915353resows
respool937643respool
restoral8810983restoral
retag63618413re_tag
retail65522073retail
retax124517973re_tax
reteam83214533reteam
retear63115483retear
retell63813643retell
retia55326113retia_
retinal75318353retinal
retold73013753retold
retook104313443retook
retools73411023retools
retore67630773retore
retorn610923433retorn
retort66831153retort
retotals838463retotals
retrial7615553retrial
reveals103812723reveals
revel84423163re_vel
revisal1038263revisal
revival1337033revival
revoke135216243revoke
revolt9316223revolt
revote94917453revote
rewan85623663re_wan
rewax155713923re_wax
rewear93012003rewear
rewoke1339521223rewoke
rewon86920583rewo_n
reword106321413reword
rewore938030163rewore
rework136619793rework
reworn98122203reworn
rewove126420083rewove
rewrap11127533rewrap
rezone153814783rezone
rhinal9510193rhinal
rial45938093r__ial
ricrac1037013ricrac
ritual6310623ritual
rival85216503r_ival
riyal84413433r_iyal
road56332113r__oad
roam67132413r__oam
roan47234203r__oan
roar46328573r__oar
rococo1036813rococo
roil46235293r__oil
roll46331653r__oll
rotl45029683r__otl
royal85014703r_oyal
rugal65916093r_ugal
rugola736293rugola
rural55821173r_ural
sacral83414413sacral
scowl1012012973_scowl
seal45654373se__al
seconals1047053seconals
second9411153second
secpar1037923secpar
sectoral10109543sectoral
sendal73314993sendal
sepal77723003se_pal
septal84513383septal
seral56336383se_ral
serial64625863serial
serosal7311153serosal
serval93913413serval
setal56430903se_tal
sexual1338413sexual
shoal83920273_shoal
skoal93811463_skoal
social8813333social
special11310303special
teal45546503te__al
tecta74215523tecta_
telial65815363telial
tepal76319583te_pal
tergal72912833tergal
thecal113310303thec_al
tical76021493tic_al
trefoil1066063trefoil
trochal1288243trochal
uncial83715223uncial
uncoil8811853uncoil
uncool8610113uncool
upcoil10126193upcoil
ureal56722683ure__al
uredial82910483uredial
veal76936813ve__al
veinal93812963veinal
venal85523213ve_nal
venial94218283venial
verbal112513663verbal
vernal93514213vernal
versal93013753versal
vestal94615573vestal
vocal104715643voc_al
weal75838683we__al
xenial133414903xenial
zeal135530333ze__al

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.376475242.0
2DLD Change Limit1127165395.57620214.5
3Display Results5395390.1733115.6
 (SQL Overall)1786915396.12529174.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.