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

225 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
bodega103493(None) 
bodegas1135481bodegas
bode75838752bode__
boded95124962bode_d
bodes84935102bode_s
bohea105013732bohe_a
codeia94112192codeia
odea56224572_ode_a
omega836382_omega
abode85518813abode__
aboded104912513abode_d
abodes94417513abode_s
bade75140883bade__
badge94819693bad_ge
badged114814793badged
badger105415083badger
badges103917373badges
barege94713543barege
bedeck1536213bedeck
bedel84219403bede_l
bedell93610043bedell
bedels94015273bedels
bedeman12168843bedeman
bedew114513043bede_w
bedews12398943bedews
beg65944133b__eg_
began86319573b__egan
begat86629723b__egat
begs75733833b__egs
belga8313233b_elga
beluga936233beluga
bema85825253b__ema
beta66234133b__eta
bide76041503bide__
bided95424963bide_d
bider85728373bide_r
biders94822803biders
bides85536773bide_s
bidet84935623bide_t
bidets95215533bidets
boa56954033bo___a
boccia12338793boccia
bod67055543bod___
bodhran1343943bodhran
bodice11711423bodice
bodied103814583bodied
bodies94524143bodies
bodily12310993bodily
boding104320063boding
bodings113711653bodings
bodkin1338923bodkin
bods76244713bod__s
body107425673bod__y
bog67852413bo__g_
bogan87519003bo__gan
bogey115220233boge_y
bogeys124510913bogeys
bogged116019283bogged
boggy126116073bo_ggy
bogs75742753bo__gs
bogy106426193bo__gy
boheas114013213boheas
bohemia1446363bohemia
boing84725553boing_
boings96416873boings
bola66035563bo__la
bolder94820933bolde_r
boldest102613063boldest
bole66448693bole__
bolero8412093bolero
boles75448603bole_s
bolete8519613bolete
boleti8413403boleti
bologna1044253bologna
bondage1138253bondage
bonded104719953bonde_d
bonder95324783bonde_r
bonders104120663bonders
bone65949323bone__
boned85133243bone_d
boner75133083bone_r
boners84825433boners
bones76446533bone_s
boney105227313bone_y
bong75633413bo_ng_
bonged105719603bonged
bongo85720943bo_ngo
bongs87828423bo_ngs
bonita8312943bonita
booed85127273booe_d
booger94816553booger
boogey124711523boogey
boogy114518323bo_ogy
bopeep1236763bopeep
bora66141633bo__ra
borage93917013borage
bordel94514573borde_l
bordels103911973bordels
border94419973borde_r
borders104317533borders
bore66051333bore__
boreal84817213boreal
boreas85421733boreas
bored85034303bore_d
boreen8314313boreen
borer75131273bore_r
borers85122683borers
bores76448253bore_s
bota66236503bo__ta
botel75121863bote_l
botels84815803botels
bough115719313bo_ugh
bourg84113843bourg_
bourgs9459993bourgs
bowed114533423bowe_d
bowel105621203bowe_l
bowels114315593bowels
bower107328183bowe_r
bowers115523703bowers
bowery146012113bowery
bowleg12369183bowleg_
bowlegs13366823bowlegs
boxed154318613boxe_d
boxer145016523boxe_r
boxers155013483boxers
boxes145625073boxe_s
boyla102912363bo_yla
bregma1134963b_regma
buddha1333173buddha
budge94619883bud_ge
budged114517243budged
budger104617713budger
budges104820133budges
budget104618123budget
coda77029343cod__a
code77347733code__
codec107120343code_c
codecs115112933codecs
coded95433183code_d
codeias103911223codeias
codein94916723codein
codeina104010323codeina
coden86128543code_n
codens94821013codens
coder86134223code_r
coders95426983coders
codes86247293code_s
codex155817583code_x
codger105814873codger
conga85419873co_nga
degas75119163__degas
deva85720983__deva
dodge86618133dod_ge
dodged107514693dodged
dodgem116710043dodgem
dodger95817053dodger
dodges96119083dodges
dodgy116611463dod_gy
donga76718423do_nga
duodena943453duodena
edema8610553_edema
elodea738673elode_a
fanega1055783fanega
fodgel1136413fodgel
forego1038903forego
fovea11310483fove_a
godet7530043gode_t
godetia945353godetia
godets8410933godets
idea59122773_ide_a
lode56240113lode__
loden66621143lode_n
lodens74315063lodens
lodes66436913lode_s
lodge76520093lod_ge
lodged913815713lodged
lodger86517693lodger
lodges86820153lodges
mega77620873__mega
mode75840303mode__
model84521693mode_l
models94216353models
modem103717143mode_m
modems114610763modems
modern939523modern
modes85537413mode_s
modest93818453modest
modica11310063modica
node513036883node__
nodes64633493node_s
nonego737013nonego
nosegay1143843nosegay
novena936763novena
oda48133043_od__a
ode47446583_ode__
odeon6411483_odeon
odes57243243_ode_s
odeum84610543_odeum
oedema936573oedema
olea46532723_ole_a
omegas936973_omegas
opera7313573_opera
podagra1143603podagra
podesta1036763podesta
podgy125610773pod_gy
podia8415283pod_ia
rode55844303rode__
rodent7519243rodent
rodeo65921093rode_o
rodeos75314503rodeos
rodes614039083rode_s
senega738173senega
soda56329383sod__a
telega736773telega
toea46732333to_e_a
toga57027413to__ga
tonga65619693to_nga
vodka1354343vod_ka
wodge107212933wod_ge
wodges117413683wodges
womera11137593womera
yodel94714083yode_l
yodels104610073yodels
yoga87418053yo__ga
zoea137118423zo_e_a

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.373479064.3
2DLD Change Limit1127162254.76623650.0
3Display Results2252250.0762960.5
 (SQL Overall)1786912255.21534264.8
 
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.