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

226 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
baht9674001(None) 
bah87755351bah_
bahts105617801bahts
bait66556001bait
bast66362411bast
bat510988951ba_t
bath95940081bath
batt65053871batt
aah616252962aah_
aahs716428562aahs
abaft10318062abaft
abet610547942abet
abut66834952abut
act59557842_act
aft66849012_aft
ah513868792_ah_
aha611246642_aha
ahi68040232_ahi
ahs68644822_ahs
ait38093902_ait
alt36467962_alt
ant37270792_ant
apt57352542_apt
art38679142_art
at212393402_a_t
att35454652_att
ba49962342ba__
baa510650422ba_a
baal67033112baal
baas66844672baas
baba88828352baba
babe86835822babe
babu85829232babu
baby116723682baby
bach116131392bach
back125535762back
bad67763152ba_d
bade75140882bade
bads77048862bads
baff124632272baff
bag67059222ba_g
bags76645502bags
bail65042802bail
baith108023132baith
baits76630582baits
bake105637512bake
bal56662722ba_l
bald76432902bald
bale66353842bale
balk105132222balk
ball66043322ball
balm85534202balm
bals66354042bals
bam78560142ba_m
bams87044452bams
ban58366842ba_n
band76740912band
bane65250432bane
bang74837002bang
bani65334962bani
bank105835752bank
bans66555142bans
banty106624002banty
bap76455842ba_p
baps86040842baps
bar58070552ba_r
barb85240062barb
bard75648862bard
bare65460522bare
barf95844412barf
bark106242152bark
barm86739602barm
barn66444642barn
bars66564092bars
bas58681752ba_s
base64847022base
bash915240162bash
bask105131422bask
bass66146782bass
baste74829982baste
basts75936932basts
bate66552422bate
bathe105822882bathe
baths105922922baths
bats66962332bats
batts76727562batts
battu75216612battu
batty105422242batty
baud74928422baud
bawd105520842bawd
bawl95326062bawl
bawty135614102bawty
bay89661642ba_y
bays97143912bays
beast76338642beast
beat66168302beat
beaut75135212beaut
beet66457542beet
belt65754032belt
bent67759912bent
best66355322best
bet58376672b_et
beth96629232beth
bhut95425712bhut
bight118728842bight
bint67355042bint
bit57070902b_it
bitt65545812bitt
blah98625062blah_
blahs105616512blahs
blast76532572blast
blat66550952blat
blet66247672blet
blot65842322blot
boart78835932boart
boast75935702boast
boat66360312boat
boho96923322boho
bolt66254172bolt
boot67759372boot
bort65960962bort
bot59680402b_ot
both96533432both
bott66548572bott
bout66353292bout
bract96332722bract
brant74742172brant
brat66055542brat
brit66350152brit
brut66537962brut
buhl95518222buhl
buhr95315382buhr
bunt65850852bunt
bust65947782bust
but55963022b_ut
butt65143742butt
cant66362032cant
cart66570342cart
cast67159902cast
cat58282342ca_t
chat95546132chat
daft85537252daft
dah78148982dah_
dahl87019222dahl
dahs88231812dahs
dart55857872dart
daut56443562daut
dawt85435942dawt
east46659102east
eat36989052ea_t
eath75735662eath
echt95722902echt
fact97142542fact
fart76860562fart
fast77052312fast
fat68178082fa_t
gait56150192gait
gast56052562gast
gat46880512ga_t
ghat86435282ghat
haet75659502haet
haft105941842haft
hah910655222hah_
haha107821062haha
hahs108333362hahs
halt76056302halt
hant75461592hant
hart76865772hart
hast76259482hast
hat67289962ha_t
hath105933912hath
haut75949732haut
kart86750802kart
kat77468292ka_t
khat116730722khat
last46260322last
lat37593402la_t
lath76640382lath
malt66254812malt
mart66865982mart
mast65959962mast
mat58083942ma_t
math95437452math
matt65752662matt
maut65448452maut
nah69847002nah_
oast47156322oast
oat39888262oa_t
oath76132152oath
pact86648722pact
pah88853592pah_
pant66061262pant
part65967462part
past65959012past
pat58089462pa_t
path99134912path
phat95837862phat
pht86030522_pht
qat125253332qa_t
raft76245912raft
rah68052402rah_
rant45864682rant
rapt67245312rapt
rat37892742ra_t
rath76037662rath
salt45758522salt
sat36288482sa_t
shat76456602shat
tact67349032tact
tahr75217152tahr
tart47566182tart
tat37690292ta_t
taut47048962taut
that75639322that
vast75045122vast
vat67863452va_t
waft106139002waft
wait75553692wait
want76156172want
wart77866082wart
wast75655852wast
wat67378922wa_t
watt75545412watt
what105434072what
yacht13417392yacht
yah99046352yah_

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.0802233637.5
2DLD Change Limit298722260.87334217.6
3Display Results2262260.0633587.3
 (SQL Overall)1786912261.016175877.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.