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

410 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
baffle1439987(None) 
baffled16418061baffled
baffler15418111baffler
baffles153710681baffles
raffle123910701raffle
waffle15369181waffle
babble94017112babble
baff124632262baff__
baffed154812172baffed
baffies153612942baffies
bafflers16356592bafflers
baffs134718052baff_s
baffy165511922baff_y
bale66353842ba__le
bangle94018952bangle
barfly14339652barfly
battle85217862battle
bauble103813212bauble
coffle14359042coffle
duffle13368532duffle
gaffe124111652gaff_e
muffle14339642muffle
piffle14418232piffle
raffled14429082raffled
raffler13339222raffler
raffles133611842raffles
riffle124210232riffle
ruffle124111672ruffle
snaffle13216242snaffle
waffie15338562waffie
waffled17357522waffled
waffler16377782waffler
waffles16329982waffles
waffly18305432waffly
zaffre21354662zaffre
abaxile1644083abaxile
abele76323253_abele
able66340533_a_ble
addle74318353_addle
aff95537613_aff__
affable15117403_affable
affine12310503_affine
affix1836003_affix
afflux1942793_afflux
afire86215913_afire
afore85818603_afore
agile65122263_agile
aisle55223193_aisle
ale36572343_a__le
amble95924633_amble
amole75724593_amole
ample94720303_ample
anele55628833_anele
angle64528873_angle
anile54634463_anile
ankle95220253_ankle
anole55330373_anole
apple94517673_apple
argle65421563_argle
axile126020513_axile
axle116424603_a_xle
azole145118033_azole
baal67033113ba_al_
baals76122703ba_als
babbled113612863babbled
babbler104012823babbler
babbles104416323babbles
babe86835813ba__be
babel95821693babel_
babels105216723babels
babul96317713babul_
babuls105413643babuls
baccae12119703baccae
bacula103112673bacula
baddie104114033baddie
bade75140883ba__de
badge94819683ba_dge
badly114918763ba_dly
baffing164011603baffing
bafflegab208793bafflegab
baffling1756053baffling
bagel85116793bagel_
bagels95712313bagels
bagful1237213bagful
bagfuls1334753bagfuls
baggie102912193baggie
bail65042803ba_il_
bailed94726653ba_iled
bailee84526013bailee
bailer85425253ba_iler
bailey115015673ba_iley
bailie83818363bailie
bails75933523ba_ils
baize164717393ba_ize
bake105637513ba__ke
bal56662723ba__l_
bald76432903ba__ld
baldly12479833baldly
baled85436443ba__led
baler75635273ba__ler
bales76250083ba__les
balk105132223ba__lk
ball66043323ba__ll
balled94926893ba_lled
baller83825203ba_ller
ballet84733973ba_llet
balls76236413ba_lls
bally105530103ba_lly
balm85534203ba__lm
bals66354043ba__ls
banal75925993banal_
bane65250423ba__ne
bangles103617413bangles
barbe95328283ba_rbe
barbel104317073barbel
barbie105018353barbie
barbule1137943barbule
barde85330773ba_rde
bare65460523ba__re
barege94713543barege
barely114716793barely
barf95844403barf__
barfed125416383barfed
barflies1338303barflies
barfs104826003barf_s
barge85631023ba_rge
bargee94624443bargee
barite84224813barite
barley115116763ba_rley
barmie103816393barmie
barque17239553barque
barre75929543ba_rre
barrel84517873barrel
barye105021493ba_rye
baryte115312883baryte
basal75722283basal_
basalt83519583basalt
bascule1136573bascule
base64847023ba__se
basely114412313basely
basil75122273basil_
basils85717473basils
basque17259083basque
bassly114610073bassly
baste74829983ba_ste
bastile9313913bastile
bate66552423ba__te
bathe105822883ba_the
battled104213123battled
battler94113383battler
battles94517683battles
battue84311003battue
baubee103215993baubee
baubles113611863baubles
baulk114914333ba_ulk
bawbee132714233bawbee
bawl95326063ba_wl_
bawled124415693ba_wled
bawler114315053ba_wler
bawls105719323ba_wls
bawtie113812143bawtie
beadle93314683beadle
beagle93612593beagle
beetle8311673beetle
befall114410643befall
befell11428713befell
beflea1147123b_eflea
before11410153before
belle75827833b_elle
bible95119413b_ible
biface1358103biface
biff125026873biff__
biffed15449883biffed
biffies152710853biffies
biffin14369103biffin
biffs134814403biff_s
biffy164711123biff_y
biflex1834953b_iflex
bifold1237223bifold
bile66147173b__ile
bindle94516263bindle
birle75023633b_irle
blaff135216483blaff__
blaffs14426623blaff_s
bluffly1833433bluffly
bobble94115143bobble
boff124727323boff__
boffed15369483boffed
boffin14359053boffin
boffo136010373boff_o
boffola1543463boffola
boffos14568193boffos
boffs134915503boff_s
boggle104511943boggle
bogle85821683b_ogle
bole66448693b__ole
boodle93215033boodle
botfly1436093botfly
bottle84916073bottle
boucle103712783boucle
bouffe14438313bouffe
boule74828043b_oule
boulle84614613boulle
brabble10349973brabble
braille939713braille
bramble133710033bramble
brattle9249253brattle
bridle94115463bridle
bubale104014623bubale
bubble94016593bubble
buckle144815193buckle
buddle104313083buddle
buff125229853buff__
buffable1844393buffable
buffalo1553723buffalo
buffed154313143buffed
buffer144512683buffer
buffet143113783buffet
buffi136112203buff_i
buffier1568403buffier
buffo135112183buff_o
buffos14447853buffos
buffs135519513buff_s
buffy165013373buff_y
bugle84721943b_ugle
bumble124216893bumble
bundle94315573bundle
bungle97116113bungle
burble104617703burble
burgle94815863burgle
bustle84015483bustle
butle75023103b_utle
cable95329913ca_ble
cackle143416923cackle
cafe95230323ca_f_e
caff125631673caff__
caffs135417373caff_s
cajole154011183cajole
candle94321483candle
cantle84522153cantle
carle74535703ca_rle
castle84918963castle
cattle85118903cattle
caudle93912913caudle
coffee144113743coffee
coffled16297363coffled
coffles152610003coffles
dabble114515193dabble
daddle94214283daddle
daff115229683daff__
daffed14429493daffed
daffier1457833daffier
daffily1735133daffily
daffs125116423daff_s
daffy155510283daff_y
daftly1335443daftly
daggle93711903daggle
dale55643983da__le
dandle84218093dandle
dangle84119303dangle
dapple1138853dapple
darkle113813943darkle
dartle73714833dartle
dawdle11399503dawdle
dayfly1633813dayfly
dazzle1536853dazzle
defile105216663defile
duffel13407753duffel
duffles14308913duffles
eagle64219483ea_gle
fable105824753fa_ble
facile112514883facile
faille93414743faille
farfel124310433farfel
farle86929243fa_rle
file75446643__file
gabble113815723gabble
gable85325523ga_ble
gadfly1434663gadfly
gaff114828153gaff__
gaffed144210203gaffed
gaffer134310133gaffer
gaffes134811103gaffes
gaffs124914653gaff_s
gaggle93412623gaggle
gale56347323ga__le
gamble115417183gamble
garble94118453garble
gargle84215463gargle
habile11515203habile
hackle154916813hackle
haffet15311703haffet
haffit1538533haffit
haggle113511983haggle
hale76052833ha__le
handle104219293handle
hantle94318203hantle
haole84820083ha_ole
hassle93711593hassle
jangle144416293jangle
kaffir16345303kaffir
kale86533753ka__le
labile8315213labile
ladle66320443la_dle
mackle143716433mackle
macle96127003ma_cle
macule104115273macule
maffia14327203maffia
maile75232213ma_ile
male66052293ma__le
mangle93921323mangle
mantle84420923mantle
maple95521143ma_ple
marble104219103marble
mayfly1734403mayfly
muffled16377783muffled
muffler15398343muffler
muffles153910443muffles
naff105128933naff__
naffed13408333naffed
naffs116213963naff_s
paddle104615143paddle
padle84522343pa_dle
pale66055013pa__le
papule102212133papule
parle75836163pa_rle
parole84425253parole
piaffe1494913piaff_e
piffled16366403piffled
piffles15368763piffles
purfle112511183purfle
rabble103818243rabble
rackle123917293rackle
raddle84816173raddle
raff104933043raff__
raffia12287703raffia
rafflers14317363rafflers
raffs115017523raff_s
raggle83712883raggle
rale45050563ra__le
ramble104519973ramble
rankle103414883rankle
rassle63813203rassle
rattle64717613rattle
refile95122373refile
riffled14338603riffled
riffler13328353riffler
riffles133911163riffles
rifle85518333_rifle
ruffe114713813ruff_e
ruffled14369153ruffled
ruffler13369723ruffler
ruffles133512263ruffles
ruffly15336673ruffly
sable74732163sa_ble
saddle83915493saddle
safe75930953sa_f_e
safely12249393safely
safrole1037253safrole
sale44959703sa__le
sample104215013sample
sawfly1535133sawfly
scuffle15266883scuffle
shuffle16276913shuffle
skiffle17225203skiffle
snaffled15285203snaffled
snaffles14246033snaffles
sniffle13287643sniffle
snuffle13267823snuffle
souffle13306793souffle
stifle93611903stifle
table75429603ta_ble
tackle123815733tackle
taffia12286903taffia
taffies133012693taffies
taffy145110823taff_y
taille63116923taille
tale46154163ta__le
tamale83717393tamale
tangle74019953tangle
tattle64115653tattle
toffee123311013toffee
trifle94012883trifle
truffle1384893truffle
vagile10310543vagile
vale74937343va__le
wabble133714843wabble
waddle114715303waddle
waff134228043waff__
waffed16459793waffed
waffies163611443waffies
wafflers17306323wafflers
wafflier1733953wafflier
waffs146315473waff_s
waggle113612303waggle
wale74546433wa__le
wamble134415753wamble
wandle105316663wandle
wangle103817503wangle
warble113516603warble
warsle93112923warsle
wattle94314213wattle
whiffle1933533whiffle
yaff135324263yaff__
yaffed16457323yaffed
yaffs145311123yaff_s
zaffar21385043zaffar
zaffer21397153zaffer
zaffir21395513zaffir
zaffres22324993zaffres

Search took 6 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.1401276364.3
2DLD Change Limit1127164105.59620142.2
3Display Results4104100.1233333.3
 (SQL Overall)1786914105.85930498.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.