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

305 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
bouts7513131(None) 
bhuts105812951bhuts
boats75635151boats
bolts76232111bolts
boots75837971boots
borts76735451borts
bots66453951bo_ts
botts75224861botts
bout66353291bout_
bruts75922951bruts
buts67247691b_uts
gouts64826171gouts
louts56330271louts
outs45746961_outs
pouts75530321pouts
routs57133411routs
touts54830391touts
aborts84916182aborts
about75229082about_
abuts75417072abuts
bahts105617802bahts
baits76630582baits
basts75936932basts
bats66962332b_ats
batts76727562batts
bauds85821042bauds
beats76042242beats
beauts86015282beauts
beets76131442beets
belts75931162belts
bents76033692bents
bests75932612bests
bets67051442b_ets
bhoots11459912bhoots
bhut95425712bhut_
bints76130182bints
bionts8612392bionts
bits66148172b_its
bitts75022592bitts
blats75132502blats
blets75324942blets
bloats85215762bloats
blots75626172blots
blubs95818152blubs
blues75127042blues
bluets87215492bluets
blunts84512892blunts
blurs74619082blurs
blurts84412642blurts
boars75229602boars
boarts84716872boarts
boas66150832bo_as
boast75935702boast
boasts85017922boasts
boat66360312boat_
bobs86340652bo_bs
bocks134526572bocks
bodes84935102bodes
bods76244722bo_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
bosuns8439382bosuns
bot59680402bo_t_
bota66236502bo_ta
botas75328782botas
both96533432bo_th
bott66548572bo_tt
bough115719312bough
boughs125414372boughs
boule74828042boule
boules84925972boules
bound84819582bound
bounds94415802bounds
bounty113411072bounty
bourg84113842bourg
bourgs9459992bourgs
bourn75518482bourn
bourns84114062bourns
bourse84414332bourse
bouse75931852bouse
bouses84931782bouses
bousy104917842bousy
bouton8311532bouton
boutons9310782boutons
bowls106121432bowls
bows96242862bo_ws
boxes145625072boxes
boyos105418282boyos
boys96737332bo_ys
bozos165216862bozos
brats75336012brats
brits76433082brits
bruits85714452bruits
brunts85215452brunts
brut66537962brut_
brute75321782brute
brutes86118682brutes
bubs86235502b_ubs
buds75235182b_uds
bugouts1036192bugouts
bugs76035912b_ugs
bums85934592b_ums
buns66243722b_uns
bunts75729802bunts
buoys104810632buoys
burs65847422b_urs
bus56950972b_u_s
buss65134912b_uss
bust65947782b_ust
busts75227692busts
but55963022b_ut_
bute66739672b_ute
butes714535872b_utes
butt65143742b_utt
butts75824252butts
bututs8409422bututs
buyouts1235202buyouts
buys95726792b_uys
clouts87017202clouts
coats75635002coats
colts76633292colts
coots75636842coots
costs77231142costs
cots68054842co_ts
counts84618272counts
coups95522472coups
courts84216172courts
couth106122492couth
couths115715412couths
cuts65841152_cuts
dauts67822242dauts
doats65224882doats
doits66223672doits
dolts65626312dolts
donuts7410582donuts
dots55647662do_ts
doubts968732doubts
doums85417642doums
flouts94315272flouts
fonts86124752fonts
foots85528282foots
forts86034452forts
fouls87221432fouls
founts94313382founts
fours85521492fours
glouts74414712glouts
gluts66120132gluts
goats65527302goats
gout56646002gout_
gouty95217362gouty
grouts75015612grouts
guts56637252_guts
holts85627912holts
hoots84830252hoots
hosts85526702hosts
hots78349332ho_ts
hours85422392hours
huts76737442_huts
jolts125018882jolts
jots116336142jo_ts
jouks165612342jouks
joust125122292joust
jousts135011272jousts
juts115930162_juts
knouts10438312knouts
lofts85518362lofts
loots55431422loots
lots47652092lo_ts
lotus55718062lotus
louis57322322louis
loups75319622loups
lours55125292lours
lout45952142lout_
mauts75927192mauts
moats75827642moats
molts76032092molts
moots75831662moots
morts75533562morts
mosts76028542mosts
mots66853162mo_ts
motts76527002motts
moues75732842moues
moults84713702moults
mounts84115072mounts
mouth105420292mouth
mouths115214532mouths
muts64839982_muts
nouns56717312nouns
nous46136982nou_s
nowts86915862nowts
nuts45032672_nuts
oats46554212_oats
obits74617552obits
oots46446442_oots
opts68124742_opts
orts46538332_orts
ouds56430112_ouds
ours47237562_ours
oust46747442_oust
ousts55225702_ousts
out38072152_out_
phuts104613502phuts
poets76024442poets
ports75934592ports
posts75228782posts
pots66452362po_ts
poufs105616062poufs
poults84613482poults
pours74623182pours
pout65752552pout_
pouty107018812pouty
puts65641752_puts
roots55933672roots
rots46454092ro_ts
roues56039352roues
roups75118902roups
roust55532062roust
rousts617016722rousts
rout46153282rout_
route55132072route
routes66129312routes
routh86423072routh
rouths95416822rouths
rubouts937982rubouts
ruts44541492_ruts
scouts84817942scouts
scuts74522522scuts
shouts94017722shouts
shuts85622482shuts
sluts54523982sluts
smuts75415712smuts
snouts64915872snouts
softs85019232softs
soots55536212soots
sorts54536662sorts
sots45552452so_ts
souks94820522souks
souls55127362souls
soups75322942soups
sours55230502sours
sous46947212sou_s
south85223572south
souths95216602souths
spouts85115112spouts
stouts65019002stouts
tauts56125512tauts
tofts84919242tofts
toits55327472toits
toots55331872toots
torts56138122torts
tots46654122to_ts
tours55325892tours
tout46753822tout_
trouts66116632trouts
tuts45838452_tuts
uts35534372__uts
volts85421292volts
wonts87621542wonts
worts88631182worts
wots76342892wo_ts
yours85217882yours
yous76230652you_s
youth115315042youth
youths124510042youths
zouks184410502zouks

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 Filter178691538000.296603685.8
2DLD Change Limit538003051.45337026.8
3Display Results3053050.0803812.5
 (SQL Overall)1786913051.82997698.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.