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

287 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
batt6505387(None) 
att35454651_att
baht96740011baht
bait66556001bait
bast66362411bast
bat510988951ba_t
bate66552421bate
bath95940081bath
bats66962331bats
batts76727561batts
battu75216611battu
batty105422241batty
bitt65545811bitt
bott66548571bott
butt65143741butt
matt65752661matt
watt75545411watt
abaft10318062abaft
abate76627842abate
abet610547942abet
abut66834952abut
abwatt11410672abwatt
act59557842_act
aft66849012_aft
ait38093902_ait
alt36467962_alt
ant37270792_ant
apt57352542_apt
art38679142_art
at212393402_a_t
ate37059242_ate
ba49962342ba__
baa510650422ba_a
baal67033112baal
baas66844672baas
baba88828352baba
babe86835822babe
babu85829232babu
baby116723682baby
bach116131392bach
back125535762back
bad67763152ba_d
bade75140882bade
bads77048862bads
baff124632272baff
bag67059222ba_g
bags76645502bags
bah87755352ba_h
bahts105617802bahts
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
batch124620102batch
bated85935532bated
bates75846342bates
bathe105822882bathe
baths105922922baths
batik11614732batik
baton75822422baton
batted95623652batted
batten85217122batten
batter84928872batter
battik1238092battik
battle85217862battle
battue84311002battue
baud74928422baud
bawd105520842bawd
bawl95326062bawl
bawty135614102bawty
bay89661642ba_y
bays97143912bays
beast76338642beast
beat66168302beat
beats76042242beats
beaut75135212beaut
beet66457542beet
belt65754032belt
bent67759912bent
best66355322best
bet58376672b_et
beta66234132beta
beth96629232beth
bets67051442bets
betta74916842betta
bhut95425712bhut
bint67355042bint
bit57070902b_it
bite66547002bite
bits66148162bits
bitts75022592bitts
bitty106119172bitty
blast76532572blast
blat66550952blat
blate75933782blate
blats75132502blats
blet66247672blet
blot65842322blot
boart78835932boart
boast75935702boast
boat66360312boat
boats75635152boats
bolt66254172bolt
boot67759372boot
bort65960962bort
bot59680402b_ot
bota66236502bota
both96533432both
bots66453952bots
botts75224862botts
bout66353292bout
bract96332722bract
brant74742172brant
brat66055542brat
brats75336012brats
bratty1159682bratty
brit66350152brit
britt75732232britt
brut66537962brut
bunt65850852bunt
bust65947782bust
but55963022b_ut
bute66739672bute
buts67247692buts
butte74924292butte
butts75824252butts
butty104020112butty
butut75522912butut
byte96521812byte
cant66362032cant
cart66570342cart
cast67159902cast
cat58282342ca_t
cate66254602cate
cats66356342cats
catty104520412catty
daft85537252daft
dart55857872dart
data56026652data
date56443322date
dato56129942dato
datto65416422datto
daut56443562daut
dawt85435942dawt
east46659102east
eat36989052ea_t
eath75735662eath
eats47054872eats
fact97142542fact
fart76860562fart
fast77052312fast
fat68178082fa_t
fate75444282fate
fats76252502fats
fatty115117412fatty
gait56150192gait
gast56052562gast
gat46880512ga_t
gate55746572gate
gats56753442gats
haet75659502haet
haft105941842haft
halt76056302halt
hant75461592hant
hart76865772hart
hast76259482hast
hat67289962ha_t
hate78450172hate
hath105933912hath
hats76858252hats
haut75949732haut
jato115822682jato
kart86750802kart
kat77468292ka_t
kata85626022kata
kats85944332kats
last46260322last
lat37593402la_t
late47560482late
lath76640382lath
lati46438272lati
lats45962702lats
latte55426302latte
latu47934182latu
malt66254812malt
mart66865982mart
mast65959962mast
mat58083942ma_t
mate65154222mate
math95437452math
mats65460292mats
matte75626842matte
matts76829182matts
maut65448452maut
mitt66145492mitt
mott66648442mott
mutt65739402mutt
natty85719142natty
nett46643232nett
oast47156322oast
oat39888262oa_t
oath76132152oath
oats46554212oats
pact86648722pact
pant66061262pant
part65967462part
past65959012past
pat58089462pa_t
pate65350462pate
path99134912path
pats66460852pats
patty104723612patty
paty95234562paty
putt66937842putt
qat125253332qa_t
qats135331342qats
raft76245912raft
rant45864682rant
rapt67245312rapt
rat37892742ra_t
rate45458762rate
rath76037662rath
rato45436972rato
rats46260372rats
ratty84819592ratty
salt45758522salt
sat36288482sa_t
sate45556102sate
sati45539332sati
scatt76030092scatt
sett45949052sett
stat47352692stat
tact67349032tact
tart47566182tart
tat37690292ta_t
tate44748602tate
tats46858132tats
tatty84720182tatty
taut47048962taut
vast75045122vast
vat67863452va_t
vats76841742vats
vatu76524332vatu
waft106139002waft
wait75553692wait
want76156172want
wart77866082wart
wast75655852wast
wat67378922wa_t
wats77555882wats
watts86923092watts
yett76434492yett

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 Limit298722870.92332364.0
3Display Results2872870.0604783.3
 (SQL Overall)1786912871.063168100.7
 
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.