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 “bouffe” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

303 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
bouffe1443831(None) 
bouffes15388631bouffes
pouffe14448261pouffe
bluff134413832bluff_
bluffed16326432bluffed
bluffer15396882bluffer
bluffs14388372bluffs
boff124727332bo_ff_
boffed15369482bo_ffed
boffo136010372bo_ffo
boffs134915502bo_ffs
boucle103712782boucle
bougie93613272bougie
boule74828042bou_le
boulle84614612boulle
bounce104014832bounce
bourne83714092bourne
bourse84414332bourse
bouse75931852bou_se
buff125229862b_uff_
buffed154313142b_uffed
buffer144512682b_uffer
buffet143113782b_uffet
buffi136112202b_uffi
buffo135112182b_uffo
buffs135519512b_uffs
buffy165013372b_uffy
coiffe1447042coiffe
pouff135215422pouff_
pouffed16365952pouffed
pouffes15408122pouffes
pouffs14418122pouffs
pouffy17395882pouffy
ruffe114713812_ruffe
souffle13306802souffle
truffe1276232truffe
baff124632273b_aff_
baffed154812173b_affed
baffle14399873baffle
baffs134718053b_affs
baffy165511923b_affy
baubee103215993baubee
bauble103813213bauble
biff125026893b_iff_
biffed15449883b_iffed
biffs134814413b_iffs
biffy164711133b_iffy
blaff135216483blaff_
blaffs14426623blaffs
blouse84714723blou_se
bludge104210973bludge
blue65328463blu__e
bluffers16405703bluffers
bluffest1664643bluffest
bluffly1833433bluffly
blume95619893blu_me
blunge94311483blunge
bobble94115143bobble
bocce114313113bo_cce
boccie123311453boccie
boche124216953bo_che
bode75838753bo__de
bodice11711423bodice
boffin14359053boffin
boffos14568193boffos
boggle104511943boggle
bogie89524103bo_gie
bogle85821683bo_gle
boite74426323bo_ite
bole66448693bo__le
bolete8519613bolete
bolide9515563bolide
bombe115519313bo_mbe
bone65949323bo__ne
bonfire1287063bonfire
bonne75124713bo_nne
bonnie85314853bonnie
bonze165119353bo_nze
boobie104015293boobie
boodle93215033boodle
boogie93515993boogie
bookie123516003bookie
bootee84323023bootee
bootie85421163bootie
booze164718913bo_oze
borage93917013borage
borane84620213borane
borate85026153borate
bore66051333bo__re
boride9415903boride
borne77926793bo_rne
bosque17257733bosque
botfly1436093botfly
bottle84916073bottle
boubou1038433boubou
bouchee143313543bouchee
boucles113113003boucles
boudin9412373boudin
bouffant1643683bouffant
bough115719313bou_gh
boughed143810263boughed
boughs125414373boughs
bought125115643bought
bougies103715183bougies
boulder103411343boulder
boules84925973boules
boulles93114123boulles
bounced123610553bounced
bouncer113811333bouncer
bounces113813683bounces
bouncy13409073bouncy
bound84819583bou_nd
bounded113613763bounded
bounden10389453bounden
bounder104215533bounder
bounds94415803bounds
bounty113411073bounty
bouquet18288263bouquet
bourg84113843bou_rg
bourgs9459993bourgs
bourn75518483bou_rn
bournes93615023bournes
bourns84114063bourns
bourree91311343bourree
bourses94014303bourses
boused95322883boused
bouses84931783bouses
bousy104917843bou_sy
bout66353293bou__t
bouton8311533bouton
bouts75131313bou_ts
bouvier1277433bouvier
bovine11712433bovine
bowfin14338353bowfin
bowse105420633bo_wse
boxful18145273boxful
bruise83412873bruise
brume95817983bru_me
brute75321783bru_te
budge94619883b_udge
buffers153310793b_uffers
buffest15298643b_uffest
buffets15317593b_uffets
buffier1568403b_uffier
buffos14447853b_uffos
bugle84721943b_ugle
bulge86419873b_ulge
bumf116126513b_umf_
bumfs125414053b_umfs
burke115122763b_urke
burse75527253b_urse
bute66739673b_u_te
butle75023103b_utle
butte74924293b_utte
chuff164812493chuff_
chuffed19316643chuffed
chuffer18337143chuffer
chuffs17427783chuffs
chuffy20445863chuffy
coff126930783co_ff_
coffee144113743coffee
coffer144112863co_ffer
coffle14359043coffle
coffs134916303co_ffs
coiffed1635413coiffed
coiffes1546803coiffes
coude85022633cou_de
coulee8323513coulee
coupe96023483cou_pe
couple104415963couple
course85117783course
cuff125327993_cuff_
cuffed154311213_cuffed
cuffs135017493_cuffs
doff116225783do_ff_
doffed14428503do_ffed
doffer133911353do_ffer
doffs125614333do_ffs
double94013993double
douce85518423dou_ce
douche124613223douche
douse66329723dou_se
duff114326643_duff_
duffel13407753_duffel
duffer134711663_duffer
duffle13368533_duffle
duffs125216623_duffs
etouffee1462303etouffee
fluff103913613fluff_
fluffed13295903fluffed
fluffer12336503fluffer
fluffs11347783fluffs
fluffy14315783fluffy
gaffe124111653_gaffe
gauffer1474423gauffer
goffer13409513go_ffer
gouge78220063gou_ge
gourde8107933gourde
griffe13438093griffe
gruff124712143gruff_
gruffed1544943gruffed
gruffer1475793gruffer
gruffs13337453gruffs
gruffy16396013gruffy
guff114624933_guff_
guffs124414823_guffs
house89131423hou_se
howff175110493howff_
howffs18535043howffs
huff135623843_huff_
huffed163710153_huffed
huffs144514743_huffs
huffy174810233_huffy
joule124918203jou_le
jounce153310733jounce
louche115212663louche
louie55023513lou_ie
lounge75211213lounge
loupe75319513lou_pe
louse56131013lou_se
louvre9425683louvre
luff104426703_luff_
luffa11409023_luffa
luffed133810823_luffed
luffs114516283_luffs
moue65835573mou__e
mouse77133003mou_se
mousse84813033mousse
muff124723863_muff_
muffed154210593_muffed
muffle14339643_muffle
muffs134114213_muffs
off96331633_o_ff_
offed12359163_o_ffed
offer114311383_o_ffer
offs107117013_o_ffs
ounce77019933_ounce
ouphe104413263_ouphe
ourie54027303_ourie
outre53922203_outre
piaffe1494913piaffe
pouf95732643pou_f_
poufed12449713poufed
poufs105616063pou_fs
pounce105214093pounce
puff125525433_puff_
puffed153510603_puffed
puffer144610733_puffer
puffs134114933_puffs
puffy164410753_puffy
roofie93411173roofie
rouble83913313rouble
rouche114714313rouche
roue45941743rou__e
rouge65423443rou_ge
rouse56634703rou_se
route55132073rou_te
ruff105127653_ruff_
ruffed134312743_ruffed
ruffes124112423_ruffes
ruffle124111673_ruffle
ruffs114516743_ruffs
scuff133914893scuff_
scuffed16298243scuffed
scuffer15328883scuffer
scuffle15266893scuffle
scuffs14419053scuffs
shuffle16276923shuffle
sluff114016813sluff_
sluffed14308303sluffed
sluffs12349583sluffs
snuff113514043snuff_
snuffed14308073snuffed
snuffer13318853snuffer
snuffle13267833snuffle
snuffs12358533snuffs
snuffy15356243snuffy
souffled15276193souffled
souffles14298123souffles
source8410673source
souse56530773sou_se
stuff113817053stuff_
stuffed14328973stuffed
stuffer13349793stuffer
stuffs123810223stuffs
stuffy15317083stuffy
suffer124314513_suffer
toff105929903to_ff_
toffee123311013toffee
toffs116016723to_ffs
toffy145310283to_ffy
touche114916173touche
toupee8316133toupee
touse55430673tou_se
tousle64514653tousle
touzle15429003touzle
truffes1356773truffes
truffle1384893truffle
tuff104528523_tuff_
tuffet122612083_tuffet
tuffs115118263_tuffs
youse85322233you_se
zouave1833573zouave

Search took 7 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 Filter1786911127160.436409841.7
2DLD Change Limit1127163036.26617988.5
3Display Results3033030.0933258.1
 (SQL Overall)1786913036.79526297.4
 
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.