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 “coat” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

382 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
coat6755834(None) 
boat66360311boat
cat58282341c_at
chat95546131chat
coact96130571coact
coal66939251coal
coapt96131521coapt
coast75236261coast
coati75624631coati
coats75634991coats
coax136922971coax
coft97939681coft
colt67158241colt
coot67860381coot
cost68057941cost
cot510483221co_t
doat56947671doat
goat56250831goat
moat66352031moat
oat39888261_oat
at212393402__at
bat510988952_bat
beat66168302beat
blat66550952blat
bloat75229922bloat
boa56954032boa_
boar66134292boar
boart78835932boart
boas66150832boas
boast75935702boast
boats75635152boats
bolt66254172bolt
boot67759372boot
bort65960962bort
bot59680402bo_t
bota66236502bota
bott66548572bott
bout66353292bout
brat66055542brat
cab78355402c_ab
cad67456362c_ad
cam78058982c_am
can57760132c_an
cant66362022cant
cap76758982c_ap
car59165562c_ar
carat75048792carat
cart66570342cart
cast67159902cast
cate66254592c_ate
cats66356342c_ats
caw86647932c_aw
cay87155982c_ay
celt65646712celt
cent67451012cent
chad105525502chad
chai95929902chai
cham115532312cham
chant105932692chant
chao95727312chao
chap114928492chap
chapt125827642chapt
char95132152char
chart105038282chart
chats105730092chats
chaw126224632chaw
chay124924872chay
cheat105732452cheat
chit96937462chit
chott103923922chott
ciao64924182ciao
cist67244962cist
clad76225822clad
clag75924572clag
clam86332292clam
clan65633922clan
clap86429042clap
clapt98027172clapt
clast76030582clast
claw95624342claw
clay95927412clay
cleat76335062cleat
cloak115214012cloak
cloot76127052cloot
clot66542422clot
clout75330462clout
coach125919452coach
coacts105314322coacts
coala77521122coala
coals76129602coals
coaly105521592coaly
coapts104614002coapts
coasts85719132coasts
coated94927032coated
coatee84327212coatee
coater84329552coater
coatis85122592coatis
cob710258752co_b
cobalt10317392cobalt
cobb106421992cobb
cobs87043142cobs
coca88030642coca
cocas95926572cocas
cock126332902cock
coco87330602coco
cod69660122co_d
coda77029342coda
codas84724242codas
code77347732code
cods76848102cods
coed77140542coed
coff126930782coff
cog69552902co_g
cogs77340032cogs
coho97524492coho
coif96337902coif
coil66439652coil
coin66645352coin
coir66327242coir
coke107038382coke
coky137526822coky
col59360352co_l
cola66541392cola
colas75436772colas
cold77338772cold
cole66956112cole
cols66553082cols
colts76633292colts
coly96940532coly
coma87134852coma
comae97128422comae
comal95125132comal
comas95833002comas
comate104124842comate
comb106632112comb
combat12316752combat
come87547702come
comet95946072comet
comp106731252comp
compt116328222compt
comte96125472comte
con510268022co_n
cone67256962cone
coni65534802coni
conk106531442conk
conn66229132conn
cons66057692cons
conte76633202conte
conto76027172conto
cony96537832cony
coo59566362co_o
coof96643272coof
cook107236932cook
cool66940492cool
coon67248942coon
coop87238652coop
coopt95929852coopt
coos67456492coos
coots75636842coots
cop711162372co_p
copal95621782copal
copay126516312copay
cope86847382cope
cops86751372cops
copy116229802copy
cor59960942co_r
coral76033452coral
cord76740922cord
core67263112core
corf95941482corf
cork106635692cork
corm85735372corm
corn69945812corn
cors66656442cors
cory96941512cory
cos510270392co_s
coset75748842coset
cosh96127622cosh
coss66143492coss
costa75523732costa
costs77231142costs
cosy97232702cosy
cotan71521782cotan
cote66648732cote
cots68054842cots
cotta75818572cotta
count74932052count
coup86729792coup
court75532762court
couth106122482couth
cove95837072cove
covet105638942covet
cow89856712co_w
cowl97530812cowl
cowpat13312032cowpat
cows97046642cows
cowy126427362cowy
cox1210346782co_x
coxa136922962coxa
coxae146115182coxae
coxal146116672coxal
coy810557552co_y
coys97537242coys
coz149345362co_z
cozy185823802cozy
crab85727672crab
craft105327662craft
crag75625302crag
cram85635492cram
crap85731842crap
crate76537402crate
craw97725262craw
crit65743712crit
croak115216632croak
croft105622682croft
cult66541152cult
cunt66243672cunt
curt67051712curt
cut57957662c_ut
cyan96419622cyan
cyst96322812cyst
czar156013132czar
doats65224882doats
doit56347852doit
dolt56649422dolt
dost57248352dost
dot47573182do_t
drat56247832drat
eat36989052_eat
eclat7523602eclat
fat68178082_fat
feat76458222feat
fiat76646642fiat
flat77147822flat
float85928572float
foal76630922foal
foam97127172foam
font77143752font
foot76248012foot
fort76456442fort
frat75648542frat
gat46880512_gat
ghat86435282ghat
gloat65427682gloat
gnat56034432gnat
goa47343802goa_
goad66830982goad
goal55829302goal
goas55239942goas
goats65527302goats
got49870442go_t
gout56646002gout
grat55651282grat
groat65531972groat
hat67289962_hat
heat77061422heat
hoar76729162hoar
hoax147718292hoax
holt77852582holt
hoot75752092hoot
host77852832host
hot67776052ho_t
ikat87626642ikat
iota45127832iota
jolt116639122jolt
jot108259022jo_t
jota116423622jota
kat77468292_kat
khat116730722khat
koa76737772koa_
koan85425032koan
koas85635092koas
korat94934432korat
kyat116025522kyat
lat37593402_lat
load56730602load
loaf76734902loaf
loam65630482loam
loan47436452loan
loath84918602loath
loft76539142loft
loot46955822loot
lost47951492lost
lot38179262lo_t
lota47233502lota
lout45952142lout
lovat8321042lovat
mat58083932_mat
meat66359602meat
moa57249182moa_
moan65832012moan
moas65545342moas
moats75827642moats
molt66356162molt
moot67653622moot
mort66758832mort
most66554202most
mot57279422mo_t
mott66648442mott
neat46356782neat
not39474662no_t
nota46830772nota
nowt78833752nowt
oaf65952882_oaf
oak76238652_oak
oar37057952_oar
oast47156322_oast
oath76132152_oath
oats46554212_oats
oca56731732oca_
ocas66729632ocas
oft67744062_oft
oot311274692_oot
opt57545542_opt
ort39465232_ort
out38072152_out
pat58089462_pat
peat65967932peat
phat95837862phat
plat66048872plat
poet65552902poet
port66059632port
post67953362post
pot58078432po_t
pout65752552pout
prat65952042prat
qat125253332_qat
rat37892742_rat
recoat84024272recoat
road56332112road
roam67132412roam
roan47234202roan
roar46328572roar
roast56230142roast
root45655922root
rot37282952ro_t
rota45834342rota
rout46153282rout
sat36288482_sat
scat65848372scat
scoot75729142scoot
scot66242602sco_t
scout75031452scout
seat47575562seat
shat76456592shat
shoat85633942shoat
skat87037892skat
slat46959022slat
soak87227662soak
soap65831132soap
soar46838672soar
soft76942822soft
soot45761052soot
sort46264812sort
sot310384292so_t
spat66548522spat
stat47352692stat
stoat57135952stoat
swat77244442swat
tat37690292_tat
teat45963632teat
that75639322that
toad55830182toad
toast55831012toast
toft77441652toft
toit46353062toit
toot45958882toot
tort46967462tort
tost48351922tost
tot38884772to_t
tout46753822tout
twat75831512twat
vat67863452_vat
volt76439532volt
wat67378922_wat
what105434072what
woad85523942woad
wont75842502wont
wort76654752wort
wost76544362wost
wot610467482wo_t
zoa128529992zoa_

Search took 2 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 Filter178691298720.0762351197.4
2DLD Change Limit298723820.94031778.7
3Display Results3823820.0934107.5
 (SQL Overall)1786913821.109161128.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.