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

204 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
ghat8643528(None) 
chat95546131chat
gat46880511g_at
ghast95621221ghast
ghats95818611ghats
ghaut95919431ghaut
gnat56034431gnat
goat56250831goat
grat55651281grat
hat67289961_hat
khat116730721khat
phat95837861phat
shat76456591shat
that75639321that
what105434071what
agha87417302agha_
aghas97014872aghas
aghast105711362aghast
aha611246642aha_
arhat8327092arhat
at212393402__at
baht96740012baht
bat510988952_bat
beat66168302beat
bhut95425712bhut
blat66550952blat
boat66360312boat
brat66055542brat
cat58282342_cat
chad105525502chad
chai95929902chai
cham115532312cham
chant105932692chant
chao95727312chao
chap114928492chap
chapt125827642chapt
char95132152char
chart105038282chart
chats105730092chats
chaw126224632chaw
chay124924872chay
cheat105732452cheat
chit96937462chit
coat67558342coat
dhak125512032dhak
dhal86719282dhal
doat56947672doat
drat56247832drat
eat36989052_eat
fat68178082_fat
feat76458222feat
fiat76646642fiat
flat77147822flat
frat75648542frat
gab67155992g_ab
gad57556652g_ad
gae46457702g_ae
gag57753632g_ag
gait56150192gait
gal46055512g_al
gam67060062g_am
gan48060122g_an
gap67055612g_ap
gar47259902g_ar
gas48870252g_as
gast56052562gast
gate55746572g_ate
gats56753442g_ats
gay76856492g_ay
gear55934972gear
gelt56448012gelt
gent56954392gent
gest56149132gest
get47467462g_et
geta56627442geta
ghauts10447782ghauts
ghazi1837432ghazi
ghee85726112ghee
ghi77019882gh_i
ghis85020162ghis
ghost96318762ghost
giant65430592giant
gift86735792gift
gilt56348542gilt
girt56646422girt
gist56046762gist
git46266052g_it
glad65624012glad
glam76529342glam
gloat65427672gloat
glut56331292glut
gnar56021382gnar
gnats65217712gnats
gnaw86515742gnaw
goa47343802goa_
goad66830982goad
goal55829302goal
goas55239942goas
goats65527302goats
got49870442g_ot
gout56646002gout
grab75427612grab
grad66829862grad
graft95327202graft
gram77034582gram
gran56335012gran
grant64840012grant
grate64932882grate
gray85329892gray
great66034242great
grit55247242grit
groat65531962groat
grot55942052grot
guan55325582guan
guar56923292guar
gust55240702gust
gut46753852g_ut
ha510259942_ha_
had77658762_had
hae67364002_hae
haet75659502_haet
haft105941842_haft
hag77255742_hag
hah910655222_hah
haj138140602_haj
halt76056302_halt
ham86363282_ham
hant75461582_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
hot67776052_hot
hut66457292_hut
ikat87626642ikat
kat77468292_kat
khaf145319602khaf
khan115819142khan
khats125316012khats
khet116328622khet
kyat116025522kyat
lat37593402_lat
mat58083932_mat
meat66359602meat
moat66352032moat
neat46356782neat
oat39888262_oat
ogham1138252ogham
pat58089462_pat
peat65967932peat
phot95534352phot
pht86030522ph_t
phut96925972phut
plat66048872plat
prat65952042prat
qat125253332_qat
rat37892742_rat
sat36288482_sat
scat65848372scat
seat47575562seat
sha69837782sha_
shad86230912shad
shaft115725252shaft
shag86430562shag
shah105627782shah
shalt85534482shalt
sham96436352sham
shaw108132552shaw
shay107133342shay
shit76745932shit
shoat85633942shoat
shot76150242shot
shut76137582shut
skat87037892skat
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.0762351197.4
2DLD Change Limit298722041.11026911.7
3Display Results2042040.0802550.0
 (SQL Overall)1786912041.266141146.1
 
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.