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

331 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
boats7563515(None) 
bats66962331b_ats
beats76042241beats
blats75132501blats
bloats85215761bloats
boars75229601boars
boarts84716871boarts
boas66150831boa_s
boast75935701boast
boasts85017921boasts
boat66360311boat_
bolts76232111bolts
boots75837971boots
borts76735451borts
botas75328781botas
bots66453951bo_ts
botts75224861botts
bouts75131311bouts
brats75336011brats
coats75635001coats
doats65224881doats
goats65527301goats
moats75827641moats
oats46554211_oats
aborts84916182aborts
baals76122702baals
baas66844672b_aas
bads77048862b_ads
bags76645502b_ags
bahts105617802bahts
baits76630582baits
bals66354042b_als
bams87044452b_ams
bans66555142b_ans
baps86040842b_aps
bars66564092b_ars
bas58681752b_a_s
bass66146782b_ass
bast66362412b_ast
basts75936932basts
bat510988952b_at_
bate66552422b_ate
bates75846342b_ates
bath95940082b_ath
baths105922922b_aths
batt65053872b_att
batts76727562batts
bays97143912b_ays
beads85429502beads
beaks115326622beaks
beams95328172beams
beans75734692beans
bears75739042bears
beast76338642beast
beasts84519722beasts
beat66168302beat_
beaus75127112beaus
beauts86015282beauts
beets76131442beets
belts75931162belts
bents76033692bents
bests75932612bests
betas75528762betas
bets67051442b_ets
bhoots11459912bhoots
bhuts105812952bhuts
bias64738162bia_s
bints76130182bints
bionts8612392bionts
biotas84313922biotas
bits66148162b_its
bitts75022592bitts
blabs95619632blabs
blahs105616512blahs
blams95023852blams
blast76532572blast
blasts85116772blasts
blat66550952blat_
blate75933782blate
blaws105620462blaws
bleats85518612bleats
blets75324942blets
bloat75229922bloat_
blots75626172blots
boa56954032boa__
boar66134292boa_r
board85523002board
boards94616932boards
boart78835932boart
boated94221972boated
boatel84314092boatel
boatels93510232boatels
boater84622092boater
boaters93419242boaters
bobcats1335992bobcats
bobs86340652bo_bs
bocks134526572bocks
bodes84935102bodes
bods76244712bo_ds
boffs134915502boffs
bogans95714812bogans
bogarts1047742bogarts
bogs75742752bo_gs
bogus85616472bogus
bohos105618252bohos
boils75427192boils
boite74426322boite
boites84322702boites
bolas74733762bolas
bolds85825282bolds
boles75448602boles
bolls75531312bolls
bolos75531372bolos
bolt66254172bolt_
bolus79125542bolus
bombs115818822bombs
bonds86126842bonds
bones76446532bones
bongs87828422bongs
bonks116326462bonks
bonus75324322bonus
boobs96221992boobs
books115729712books
booms95427122booms
boons75031912boons
boors74325012boors
boos67955032bo_os
boost75132472boost
boosts86115012boosts
boot67759372boot_
booth105522012booth
booths115313792booths
booty106125912booty
bops86037982bo_ps
borals86721912borals
boras75938302boras
borate85026152borate
borates94823012borates
bores76448252bores
borks115727702borks
bort65960962bort_
borty105522832borty
bortz165722202bortz
bos57966812bo__s
bosks115218852bosks
boss65938342bo_ss
bot59680402bo_t_
bota66236502bo_ta
both96533432bo_th
bott66548572bo_tt
bout66353292bout_
bowls106121432bowls
bows96242862bo_ws
boxes145625072boxes
boyars115611982boyars
boyos105418282boyos
boys96737332bo_ys
bozos165216862bozos
bracts105617772bracts
brads85528292brads
braes75735052braes
brags85625102brags
brans75437432brans
brants85723052brants
bras65746452bra_s
brass75428022brass
brat66055542brat_
braws106425192braws
brays106723112brays
brits76433082brits
broads94515152broads
bruts75922952bruts
bunts75729802bunts
busts75227692busts
buts67247692b_uts
butts75824252butts
cats66356342_cats
chats105730092chats
coacts105314332coacts
coals76129602coals
coapts104614012coapts
coast75236272coast
coasts85719142coasts
coat67558352coat_
coati75624642coati
coatis85122602coatis
colts76633292colts
coots75636842coots
costs77231142costs
cots68054842co_ts
doat56947672doat_
doits66223672doits
dolts65626312dolts
dots55647662do_ts
drats66628372drats
eats47054872_eats
fats76252502_fats
feats86432752feats
fiats85324482fiats
flats86429742flats
floats96816252floats
foals85721692foals
foams105017952foams
fonts86124752fonts
foots85528282foots
forts86034452forts
frats86829672frats
gats56753442_gats
ghats95818612ghats
gloats74515422gloats
gnats65217712gnats
goads77022852goads
goals65521292goals
goas55239942goa_s
goat56250832goat_
gouts64826172gouts
groats74816652groats
hats76858252_hats
heats85838402heats
hoars85925552hoars
holts85627912holts
hoots84830252hoots
hosts85526702hosts
hots78349332ho_ts
ikats95311152ikats
iotas54821112iotas
jolts125018882jolts
jotas125717442jotas
jots116336142jo_ts
kats85944332_kats
khats125316012khats
koans95818622koans
koas85635092koa_s
korats105416062korats
kyats125012442kyats
lats45962702_lats
loads65323372loads
loafs85616992loafs
loams75619862loams
loans56026462loans
loath84918602loath
lofts85518362lofts
loots55431422loots
lotas55926302lotas
lots47652092lo_ts
louts56330272louts
lovats939072lovats
mats65460292_mats
meats75034052meats
moans74624372moans
moas65545342moa_s
moat66352032moat_
molts76032092molts
moots75831662moots
morts75533562morts
mosts76028542mosts
mots66853162mo_ts
motts76527002motts
neats55931902neats
nowts86915862nowts
oafs76425262_oafs
oaks86527902_oaks
oars46846032_oars
oast47156322_oast
oasts56529182_oasts
oat39888262_oat_
oath76132152_oath
oaths86117312_oaths
obas65730932oba_s
obits74617552obits
oots46446442_oots
opts68124742_opts
orts46538332_orts
outs45746962_outs
pats66460852_pats
peats76140192peats
plats75531372plats
poets76024442poets
ports75934592ports
posts75228782posts
pots66452362po_ts
pouts75530322pouts
prats76333392prats
qats135331342_qats
rats46260372_rats
roads66523622roads
roams74919612roams
roans54926442roans
roars55622242roars
roast56230142roast
roasts64915412roasts
roots55933672roots
rotas54827722rotas
rots46454092ro_ts
routs57133412routs
scats75930602scats
seats54844342seats
shoats94117082shoats
skats94621542skats
slats55436902slats
soaks95220292soaks
soaps75120712soaps
soars54732512soars
softs85019232softs
soots55536212soots
sorts54536662sorts
sots45552452so_ts
spats75031382spats
stats55933362stats
stoats65117482stoats
swats85726862swats
tats46858132_tats
teats55636812teats
toads65621072toads
toast55831012toast
toasts65914992toasts
tofts84919242tofts
toits55327472toits
toots55331872toots
torts56138122torts
tots46654122to_ts
touts54830392touts
twats86616602twats
vats76841742_vats
volts85421292volts
wats77555882_wats
whats117718992whats
woads94818442woads
wonts87621542wonts
worts88631182worts
wots76342892wo_ts

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.313570897.8
2DLD Change Limit538003311.62333148.5
3Display Results3313310.0963447.9
 (SQL Overall)1786913312.03287938.5
 
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.