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

256 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
chat9554613(None) 
cat58282341c_at
chad105525501chad
chai95929901chai
cham115532311cham
chant105932691chant
chao95727311chao
chap114928491chap
chapt125827641chapt
char95132151char
chart105038281chart
chats105730091chats
chaw126224631chaw
chay124924871chay
cheat105732451cheat
chit96937461chit
coat67558351coat
ghat86435281ghat
hat67289961_hat
khat116730721khat
phat95837861phat
shat76456601shat
that75639321that
what105434071what
aha611246642aha_
arhat8327092arhat
at212393402__at
baht96740012baht
bat510988952_bat
beat66168302beat
bhut95425712bhut
blat66550952blat
boat66360312boat
brat66055542brat
cab78355402c_ab
cad67456362c_ad
cam78058982c_am
can57760142c_an
cant66362032cant
cap76758982c_ap
car59165562c_ar
carat75048792carat
cart66570342cart
cast67159902cast
cate66254602c_ate
cats66356342c_ats
caw86647932c_aw
cay87155982c_ay
celt65646712celt
cent67451012cent
chads116122232chads
chaeta11310682chaeta
chafe135117352chafe
chaff165016282chaff
chain105723672chain
chair105519632chair
chais107530312chais
chalet113825992chalet
chalk144814602chalk
chalot113020132chalot
champ145017962champ
chams126028502chams
chang115418562chang
chants115020392chants
chanty145215822chanty
chaos105622862chaos
chape125221142chape
chaps125326062chaps
chard116124742chard
chare105231982chare
chark144222712chark
charm126124662charm
charr104821782charr
chars105936642chars
charts115823092charts
chary135023132chary
chase105127122chase
chasm125518792chasm
chaste114617392chaste
chatty14419362chatty
chaunt11613492chaunt
chaws135022462chaws
chays135319742chays
cheap126915942cheap
cheats114519542cheats
chef125125622chef
chert105232102chert
chest104926142chest
cheth135013822cheth
chew126622132chew
chez184519022chez
chi86228652ch_i
chia96026622chia
chiao105618362chiao
chias104625522chias
chic115925202chic
chid106626402chid
chin96934742chin
chip116726422chip
chis95933312chis
chits105424572chits
chon96627792chon
chop116024922chop
chott103923932chott
chow125820992chow
chub115516412chub
chug105914112chug
chum116318002chum
chute104316462chute
ciao64924182ciao
cist67244962cist
clad76225822clad
clag75924572clag
clam86332292clam
clan65633922clan
clap86429042clap
clapt98027172clapt
clast76030582clast
claw95624342claw
clay95927412clay
cleat76335062cleat
clot66542422clot
coact96130582coact
coal66939252coal
coapt96131532coapt
coast75236272coast
coati75624642coati
coats75635002coats
coax136922982coax
coft97939682coft
colt67158242colt
coot67860382coot
cost68057942cost
cot510483222c_ot
crab85727672crab
craft105327662craft
crag75625302crag
cram85635492cram
crap85731842crap
crate76537402crate
craw97725262craw
crit65743712crit
cult66541152cult
cunt66243672cunt
curt67051712curt
cushat113513692cushat
cut57957662c_ut
cyan96419622cyan
cyst96322812cyst
czar156013132czar
dhak125512032dhak
dhal86719282dhal
doat56947672doat
drat56247832drat
eat36989052_eat
echt95722902ech_t
eclat7523602eclat
fat68178082_fat
feat76458222feat
fiat76646642fiat
flat77147822flat
frat75648542frat
gat46880512_gat
ghast95621222ghast
ghats95818612ghats
ghaut95919432ghaut
gnat56034432gnat
goat56250832goat
grat55651282grat
ha510259942_ha_
had77658762_had
hae67364002_hae
haet75659502_haet
haft105941842_haft
hag77255742_hag
hah910655222_hah
haj138140602_haj
halt76056302_halt
ham86363282_ham
hant75461592_hant
hao67251122_hao
hap87360052_hap
hart76865772_hart
has67372652_has
hast76259482_hast
hate78450172_hate
hath105933912_hath
hats76858252_hats
haut75949732_haut
haw97153272_haw
hay97358772_hay
heat77061422heat
het67674312_het
hit66569192_hit
hot67776062_hot
hut66457292_hut
ikat87626642ikat
kat77468292_kat
khaf145319602khaf
khan115819142khan
khats125316012khats
khet116328622khet
kyat116025522kyat
lat37593402_lat
mat58083942_mat
meat66359602meat
moat66352032moat
neat46356782neat
oat39888262_oat
pat58089462_pat
peat65967932peat
phot95534362phot
pht86030522ph_t
phut96925972phut
plat66048872plat
prat65952042prat
qat125253332_qat
rat37892742_rat
sat36288482_sat
scat65848372scat
schav1338312schav
seat47575562seat
sha69837782sha_
shad86230912shad
shaft115725272shaft
shag86430562shag
shah105627782shah
shalt85534492shalt
sham96436362sham
shaw108132552shaw
shay107133342shay
shit76745942shit
shoat85633952shoat
shot76150262shot
shut76137592shut
skat87037902skat
slat46959022slat
spat66548522spat
stat47352692stat
swat77244442swat
tat37690292_tat
teat45963632teat
thae76825562thae
than76128772than
thaw107521312thaw
twat75831512twat
unhat81119262unhat
vat67863452_vat
wat67378922_wat
wha96422072wha_
wham125321692wham
whap125119642whap
whats117718992whats
wheat114924572wheat
whet105133782whet
whit104834172whit

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.283631417.0
2DLD Change Limit298722560.76339150.7
3Display Results2562560.0634063.5
 (SQL Overall)1786912561.109161128.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.