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

189 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
lakebed143478(None) 
lakebeds1542581lakebeds
labeled102510562labeled
lackered15108682lackered
lackeyed18104512lackeyed
ladened979052ladened
lagered92311152lagered
laked105731122lak__ed
lambed115614782la_mbed
lapeled10258892lapeled
latened8711922latened
layered11259412layered
likened12267352likened
wakened1546872wakened
abed79734133_a__bed
akee85936813_ake_e_
akees96119243_ake_es
akene95818663_akene_
akenes104817343_akenes
aliened81011743aliened
alkene104114003alkene_
alkenes114212753alkenes
alleged9389323alleged
altered83215743altered
aneled74719283_aneled
awakened1653473awakened
baked126130773bak__ed
barbed115121313ba_rbed
blabbed11357813bla_bbed
blackened1845273blackened
blanketed1643913blanketed
blazered2035063blazered
cabbed135416263ca_bbed
caked126128623cak__ed
cameoed1238383cameoed
cankered153010223cankered
capered123014043capered
casketed1534953casketed
catered103117773catered
clavered14187633clavered
dabbed124416143da_bbed
dackered16116893dackered
daikered1495223daikered
darkened1435943darkened
daubed104611783da_ubed
davened124610073davened
daybed13438673da_ybed
easeled8159863easeled
faceted13509563faceted
faked135225483fak__ed
fakeer13378743fake_er
flaked144715653flak__ed
flambeed16324383flambeed
flatbed13397983fla_tbed
gabbed125216893ga_bbed
garbed104815663ga_rbed
gaveled12399133gaveled
glaceed1136203glace_ed
hakeem15407383hake_em
hankered16289443hankered
harkened1637483harkened
havened14429243havened
havered144011453havered
hawkeyed2242403hawkeyed
jabbed184213483ja_bbed
jacketed22146533jacketed
jambed184811403ja_mbed
kerbed13339703__kerbed
keyed1369393__keyed
laagered1055853laagered
label75019383la__bel
labeler92310183labeler
labelled11278293labelled
labored102810253labored
laced87132643la__ced
lacked135324653la_cked
laddered1136743laddered
laded74232613la__ded
ladled85013483la_dled
lagend838743lage_nd
lagged95520133la_gged
laired75216813la_ired
lake85741603lak__e_
laker95432873lak__er
lakers105225153lake_rs
lakes95737653lak__es
lakeside1344673lakeside
lakier104716273lak_ier
lalled74218753la_lled
lamber104418493la_mber
lamed85235293la__med
lamented1138193lamented
lammed113915623la_mmed
lamped114017543la_mped
lanated8313203lanated
lanced93717723la_nced
lanceted1137073lanceted
landed84619243la_nded
lapelled11227083lapelled
lapped114320033la_pped
lappered13288213lappered
lappeted13255833lappeted
lapsed94712583la_psed
larded84319093la_rded
laree56036293lare_e_
larees65323113lare_es
larked114519473la_rked
lased65132343la__sed
lashed105625213la_shed
lassoed8408743lassoed
lasted74323603la_sted
latched133914073latched
lated65240673la__ted
lateen64014863late_en
laterad8310843laterad
latexes1438313latexes
lathed104718463la_thed
lathered121512333lathered
lauded83812153la_uded
laughed1235893laughed
laureled934543laureled
laved95028593la__ved
laveer94110423lave_er
laveered1235253laveered
lawed96028323la__wed
lawyered1534033lawyered
layed95127383la__yed
lazed154925843la__zed
lazied164610653la_zied
leadened1036153leadened
leaked114217703leak__ed
leavened1235553leavened
leben7314853l__eben
leered73816223l_eered
lekked10395633lek_ked
leveed104111373leve_ed
leveled114010383leveled
levered114212303levered
libeled10249413libeled
liked104523813lik__ed
limbed114513183l_imbed
linebred1144963linebred
livened11238933livened
livered113111633livered
lobbed113114613l_obbed
lobed86022133l__obed
lowered112711913lowered
lubed85319893l__ubed
marketed1537323marketed
nabbed115113613na_bbed
naked105320853nak__ed
nakeder1254363nakeder
packeted17148283packeted
paneled10612573paneled
papered122513173papered
paveed12438893pave_ed
racemed1237013racemed
racketed15169123racketed
raked105831423rak__ed
rakee96031173rake_e_
rakees104516973rake_es
raveled114113633raveled
ravened115012283ravened
razeed163710013raze_ed
rekeyed1536163rekeyed
sabbed114518083sa_bbed
sabed86526813sa__bed
sabered103213023sabered
skeed105018983_ske_ed
skewed145610233_skewed
slabbed12409503sla_bbed
slackened1644243slackened
slaked114318273slak__ed
slavered12188033slavered
tabbed114215363ta_bbed
tabered103311593tabered
tapered102612933tapered
tokened1236393tokened
vakeel1335193vake_el
valeted1139013valeted
wafered14288433wafered
wagered12299333wagered
waked135626753wak__ed
wakener1446913wakener
waterbed1436443waterbed
watered113014953watered
wavered142910433wavered
weakened1634823weakened
yakked13366093yak_ked

Search took 8 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 Filter1786911340270.390458182.1
2DLD Change Limit1340271896.53320515.4
3Display Results1891890.0603150.0
 (SQL Overall)1786911896.98325589.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.