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

245 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
botts7522486(None) 
batts76727561batts
bitts75022591bitts
boats75635151boats
bolts76232111bolts
boots75837971boots
borts76735451borts
botas75328781botas
bots66453951bo_ts
bott66548571bott_
bouts75131311bouts
butts75824251butts
motts76527001motts
aborts84916182aborts
bahts105617802bahts
baits76630582baits
basts75936932basts
bates75846342bates
baths105922922baths
bats66962332b_ats
batt65053872batt_
battu75216612battu
batty105422242batty
beats76042242beats
beets76131442beets
belts75931162belts
bents76033692bents
bests75932612bests
betas75528762betas
beths105519222beths
bets67051442b_ets
betta74916842betta
bettas84913922bettas
bhoots11459912bhoots
bhuts105812952bhuts
bints76130182bints
bionts8612392bionts
biotas84313922biotas
bites75641172bites
bits66148162b_its
bitt65545812bitt_
bitty106119172bitty
blats75132502blats
blets75324942blets
bloats85215762bloats
blots75626172blots
blotto8198442blotto
blotty11178342blotty
boars75229602boars
boarts84716872boarts
boas66150832bo_as
boast75935702boast
boasts85017922boasts
boat66360312boat_
bobs86340652bo_bs
bocks134526572bocks
bodes84935102bodes
bods76244712bo_ds
boffs134915502boffs
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
boras75938302boras
bores76448252bores
borks115727702borks
bort65960962bort_
borty105522832borty
bortz165722202bortz
bos57966812bo__s
bosks115218852bosks
boss65938342bo_ss
bot59680402bo_t_
bota66236502bo_ta
botch126717452botch
botel75121862botel
botels84815802botels
both96533432bo_th
bothy136713962bothy
bottle84916072bottle
bottles94216272bottles
bottom1048722bottom
bottoms1136992bottoms
bout66353292bout_
bowls106121432bowls
bows96242862bo_ws
boxes145625072boxes
boyos105418282boyos
boys96737332bo_ys
bozos165216862bozos
brats75336012brats
brits76433082brits
britts84813442britts
broths115013922broths
bruts75922952bruts
bunts75729802bunts
busts75227692busts
butes714535872butes
buts67247692b_uts
butt65143742butt_
butte74924292butte
buttes84822562buttes
butty104020112butty
bututs8409422bututs
bytes105217492bytes
chotts113610992chotts
coats75635002coats
colts76633292colts
coots75636842coots
costs77231142costs
cotes76347842cotes
cots68054842co_ts
cotta75818572cotta
cottas84615572cottas
doats65224882doats
doits66223672doits
dolts65626312dolts
dotes65836692dotes
dots55647662do_ts
dotty94516102dotty
fonts86124752fonts
foots85528282foots
forts86034452forts
goats65527302goats
goths96513002goths
gouts64826172gouts
holts85627912holts
hoots84830252hoots
hosts85526702hosts
hots78349332ho_ts
iotas54821112iotas
jolts125018882jolts
jotas125717442jotas
jots116336142jo_ts
jotty155012602jotty
kotos95717702kotos
lofts85518362lofts
loots55431422loots
lotas55926302lotas
lotos54724632lotos
lots47652092lo_ts
lotte54923852lotte
lottes65322752lottes
lotto55217572lotto
lottos64613102lottos
lotus55718062lotus
louts56330272louts
matts76829182matts
mitts75523752mitts
moats75827642moats
molts76032092molts
moots75831662moots
morts75533562morts
mosts76028542mosts
motes75944002motes
motets84216192motets
moths106021552moths
mots66853162mo_ts
mott66648442mott_
motte75526972motte
mottes85523692mottes
motto76119512motto
mottos84615242mottos
mutts75120252mutts
netts55320722netts
notes55034582notes
nowts86915862nowts
oats46554212_oats
obits74617552obits
oots46446442_oots
opts68124742_opts
orts46538332_orts
otto45220642_otto
ottos54714322_ottos
outs45746962_outs
poets76024442poets
ports75934592ports
posts75228782posts
pots66452362po_ts
potto75320942potto
pottos84615872pottos
potty105621002potty
pouts75530322pouts
putts75719272putts
roots55933672roots
rotas54827722rotas
rotes56143902rotes
rotis56327062rotis
rotls55620162rotls
rotos56027882rotos
rots46454092ro_ts
rotte54625932rotte
rottes64524832rottes
routs57133412routs
setts55124322setts
shotts93614702shotts
softs85019232softs
soots55536212soots
sorts54536662sorts
soths86218632soths
sots45552452so_ts
stots54828552stots
stotts64612862stotts
tofts84919242tofts
toits55327472toits
toots55331872toots
torts56138122torts
totes55139682totes
tots46654122to_ts
touts54830392touts
volts85421292volts
votes84627082votes
watts86923092watts
wonts87621542wonts
worts88631182worts
wots76342892wo_ts
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.296603685.8
2DLD Change Limit538002451.72031279.1
3Display Results2452450.0633888.9
 (SQL Overall)1786912452.07985950.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.