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

250 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
batts7672756(None) 
bahts105617801bahts
baits76630581baits
basts75936931basts
bates75846341bates
baths105922921baths
bats66962331ba_ts
batt65053871batt_
battu75216611battu
batty105422241batty
bitts75022591bitts
botts75224861botts
butts75824251butts
matts76829181matts
watts86923091watts
abates85825032abates
abatis84317932abatis
abattis9297822abattis
abets75621672abets
abuts75417072abuts
abwatts1233402abwatts
acts66929862_acts
aits46355532_aits
alts46639902_alts
ants47243472_ants
arts49650262_arts
ates45047922_ates
att35454652_att_
baals76122702baals
baas66844672ba_as
babas96325732babas
babes95834112babes
babus95620332babus
backs135729622backs
bads77048862ba_ds
baffs134718052baffs
bags76645502ba_gs
baht96740012baht_
bails75933522bails
bait66556002bait_
baith108023132baith
bakes117035372bakes
balas76937212balas
balds85524642balds
bales76250082bales
balks114926292balks
balls76236412balls
balms95723922balms
bals66354042ba_ls
bams87044452ba_ms
bands85233422bands
banes74945582banes
bangs85627772bangs
banks115527902banks
banns75321232banns
bans66555142ba_ns
banty106624002banty
baps86040842ba_ps
barbs95928192barbs
bards87139642bards
bares75457132bares
barfs104826002barfs
barks115735812barks
barms96128462barms
barns76335142barns
bars66564092ba_rs
bas58681752ba__s
bases75644352bases
basis75429862basis
basks115621762basks
bass66146782ba_ss
bast66362412bast_
baste74829982baste
bastes85330382bastes
bat510988952ba_t_
batch124620102batch
bate66552422ba_te
bated85935532bated
bath95940082ba_th
bathe105822882bathe
bathes116524832bathes
bathos116215632bathos
batik11614732batik
batiks1239372batiks
baton75822422baton
batons85519422batons
batted95623652batted
batten85217122batten
battens95313262battens
batter84928872batter
batters94626012batters
battik1238092battik
battiks1337142battiks
battle85217862battle
battles94517682battles
battue84311002battue
battues94610192battues
bauds85821042bauds
bawds116115492bawds
bawls105719322bawls
bawty135614102bawty
bays97143912ba_ys
beasts84519722beasts
beats76042242beats
beauts86015282beauts
beets76131442beets
belts75931162belts
bents76033692bents
bests75932612bests
betas75528762betas
beths105519222beths
bets67051442b_ets
betta74916842betta
bettas84913922bettas
bhuts105812952bhuts
bints76130182bints
bites75641172bites
bits66148162b_its
bitt65545812bitt_
bitty106119172bitty
blasts85116772blasts
blats75132502blats
blets75324942blets
blots75626172blots
boarts84716872boarts
boasts85017922boasts
boats75635152boats
bolts76232112bolts
boots75837972boots
borts76735452borts
botas75328782botas
bots66453952b_ots
bott66548572bott_
bouts75131312bouts
bracts105617772bracts
brants85723052brants
brats75336012brats
bratty1159682bratty
brits76433082brits
britts84813442britts
bruts75922952bruts
bunts75729802bunts
busts75227692busts
butes714535872butes
buts67247692b_uts
butt65143742butt_
butte74924292butte
buttes84822562buttes
butty104020112butty
bututs8409422bututs
bytes105217492bytes
cants77036942cants
carts78946292carts
casts77237792casts
cates75951892cates
cats66356342ca_ts
catty104520412catty
darts67635732darts
dates65639152dates
datos65222782datos
datto65416422datto
dattos74311902dattos
dauts67822242dauts
dawts97216122dawts
easts57530322easts
eats47054872ea_ts
facts107021892facts
farts88336842farts
fasts86429682fasts
fates85139232fates
fats76252502fa_ts
fatty115117412fatty
gaits65726012gaits
gasts66628632gasts
gates65939512gates
gats56753442ga_ts
haets86525122haets
hafts116219462hafts
halts85230102halts
hants86335402hants
harts88441592harts
hates86742572hates
hats76858252ha_ts
jatos125116822jatos
karts97630112karts
katas95922092katas
kats85944332ka_ts
lasts57731262lasts
laths86022402laths
lats45962702la_ts
latte55426302latte
lattes65324202lattes
malts76331752malts
marts77442232marts
masts77035762masts
mates75251362mates
maths105624022maths
mats65460292ma_ts
matt65752662matt_
matte75626842matte
mattes85624532mattes
mauts75927192mauts
mitts75523752mitts
motts76527002motts
mutts75120252mutts
nates55238332nates
natty85719142natty
netts55320722netts
oasts56529182oasts
oaths86117312oaths
oats46554212oa_ts
pacts95125802pacts
pants76536922pants
parts77743372parts
pasts75936502pasts
pates76047892pates
paths105521382paths
pats66460852pa_ts
patty104723612patty
putts75719272putts
qats135331342qa_ts
rafts87820632rafts
rants55935342rants
rates55352012rates
ratos55528762ratos
rats46260372ra_ts
ratty84819592ratty
salts55431882salts
sates54949322sates
satis55633682satis
scatts85914662scatts
setts55124322setts
stats55933362stats
tacts76524122tacts
tarts57242022tarts
tates55444982tates
tats46858132ta_ts
tatty84720182tatty
tauts56125512tauts
vasts86423772vasts
vats76841742va_ts
vatus86114642vatus
wafts116920552wafts
waits88333522waits
wants87932212wants
warts814840402warts
wasts87433672wasts
wats77555882wa_ts
watt75545412watt_
yetts86715132yetts

Search took 3 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 Filter178691538000.326548131.9
2DLD Change Limit538002501.81329674.6
3Display Results2502500.0803125.0
 (SQL Overall)1786912502.21980527.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.