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

126 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
slumbery1529604(None) 
plumbery17315531plumbery
slumber113811001slumber_
slumbers123110271slumbers
blubbery14294782blubbery
clumber134011442clumber_
clumbers143910412clumbers
flummery1833052flummery
lumber103817772_lumber_
lumberly1544682_lumberly
lumbers113815912_lumbers
plumber13339982plumber_
plumbers14418512plumbers
slabbery15375772slabbery
slobbery15375662slobbery
slubber113010762slubber_
slubbers12349942slubbers
slumbered14215592slumbered
slumberer13194802slumberer
slummer113711202slummer_
slummers12358932slummers
summery14329412s_ummery
ambery133811133__ambery
blubber10399293blubber_
blubbers11408143blubbers
blueberry1642773blueberry
blustery13368003blustery
clamber133311743clamber_
clambers144211293clambers
climber13449133climber_
climbers14318413climbers
clubber13319593clubber_
clubbers14378583clubbers
clustery13317113clustery
cluttery13346323cluttery
columbary1842963columbary
crumber13339643crumber_
crumbers14338243crumbers
cumber124016703_cumber_
cumbers134515413_cumbers
daubery13396213dau_bery
dumber114414173_dumber_
flubber14287713flubber_
flubbers15346893flubbers
fluttery14376143fluttery
glummer12417983glummer_
lamber104418493_lamber_
lambers113817113_lambers
lambert113617113_lambert
limber104316793_limber_
limberly1544463_limberly
limbers113614743_limbers
lubber104214623_lubber_
lubberly1543663_lubberly
lubbers113913723_lubbers
lumbar103610593_lumbar_
lumbars11289763_lumbars
lumbered13188233_lumbered
lumberer12177583_lumberer
lumper103816653_lumper_
lumpers113514483_lumpers
mummery13336663_mummery
number103913223_number_
numbers113711243_numbers
plumbed14317273plumbe_d
plumier113510043plumier_
plummer13298523plummer_
plumper13318773plumper_
plumpers14357293plumpers
rubbery14337593_rubbery
scullery13296333scullery
scummer13398753scummer_
scummers14277783scummers
shimmery18265253shimmery
shrubbery1941703shrubbery
shuddery16263413shuddery
slabber113311393slabber_
slabbers123610123slabbers
slammer113913033slammer_
slammers123511223slammers
slavery13407893sl_avery
slimier93212013slimier_
slimmer114211343slimmer_
slimmers12369633slimmers
slippery15275863slippery
slithery14356703slithery
slobber11388903slobber_
slobbers12398523slobbers
slubbed12339283slubbe_d
slubbered14175253slubbered
slugger93610683slugger_
sluggers10348483sluggers
slumberers14203683slumberers
slumbering15105323slumbering
slumberous1443363slumberous
slumlord1141833slumlord
slummed12359273slumme_d
slummier1235473slummier_
slummy13325863slum__my
slumped123710153slumpe_d
slurry9378603slu__rry
snobbery15514293snobbery
snubber11277733snubber_
snubbers12326673snubbers
snuggery13253973snuggery
somber103714003s_omber_
somberly1544053s_omberly
spluttery14293623spluttery
spumier1137903spumier_
sputtery13366473sputtery
stemmery15334693stemmery
stumbler1235813stumbler_
stumblers1334383stumblers
stumper113610093stumper_
stumpers12318313stumpers
suber74924503s_u_ber_
subers85722643s_u_bers
summary14297353s_ummary
summer104017713s_ummer_
summerly15275103s_ummerly
summers113616503s_ummers
surgery11319213s_urgery
timbery14256893_timbery
trumpery1533613trumpery
umber94617593__umber_
umbers104215213__umbers

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621266.53022383.2
3Display Results1261260.0462739.1
 (SQL Overall)1786911266.99925530.9
 
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.