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 “shlumped” 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
shlumped164344(None) 
schlumped1941951schlumped
slumped123710151s_lumped
chumped17379492ch_umped
clumped143610662_clumped
flumped15377712_flumped
humped144015242_h_umped
lumped114216962__lumped
plumped14318642_plumped
shlepped1633642shlepped
shlump1345712shlump__
shlumps1434142shlump_s
shlumpy1742862shlump_y
shrimped1634212shrimped
slummed12359272s_lummed
slurped10368752s_lurped
stumped124210152s_tumped
thumped15387412th_umped
whumped18335632wh_umped
blumed114313643_blum_ed
bumped134414003__bumped
champed174111483ch_amped
chomped17329773ch_omped
chummed17396443ch_ummed
clamped144012043_clamped
clomped14398973_clomped
columned1334923columned
crumped144311223_crumped
dumped123814493__dumped
flumed124915263_flum_ed
galumphed1841423galumphed
gazumped2341403gazumped
grumped13337333_grumped
hummed144812673_h_ummed
humper134115883_h_umper
humphed1835423_h_umphed
illumed10285863illum_ed
jumped183511553__jumped
lamped114017543__lamped
limped114817123__limped
lumpen104010663__lumpen
lumper103816653__lumper
mumped133813163__mumped
plumbed14317273_plumbed
plumed114412883_plum_ed
plumiped1533313_plumiped
plumpen13276403_plumpen
plumper13318773_plumper
pumped133915563__pumped
relumed1069813relum_ed
repumped1534383repumped
saluted84511713salu_ted
scamped144711963s_camped
schlepped1942233schlepped
schlump1643263schlump__
schlumpier1941473schlumpier
schlumps1742743schlump_s
schlumpy2041873schlump_y
scrimped1555313scrimped
scrummed1554313scrummed
sculped12398253s_culped
scummed14347913s_cummed
shamed125120213sh_am_ed
shammed153911423sh_ammed
shammied16265543shammied
shaped125020103sh__aped
sharped134112053sh_arped
shauled1148793shau_led
shimmed15338583sh_immed
shimmied16294983shimmied
shipped153312103sh_ipped
shlemiel1393823shlemiel
shlumping1733373shlumping
shopped153512213sh_opped
shouted113911553shou_ted
shrimper1544413shrimper
shrugged1433673shrugged
shucked17389833sh_ucked
shunned11417843sh_unned
shunted11339783sh_unted
shushed14348493sh_ushed
shuted103913173sh_u_ted
siruped1036013siru_ped
skimped16256223s_kimped
slammed123511103s_lammed
slapped123511853s_lapped
slimed94915123s_lim_ed
slimmed12368473s_limmed
sliped95417063s_l_iped
slipped124711743s_lipped
sloped94216853s_l_oped
slopped123511443s_lopped
slubbed12339283s_lubbed
sludged103610343s_ludged
slued64220513s_lu__ed
sluffed14308303s_luffed
slugged104410383s_lugged
sluiced1046053s_luiced
slumber113811003s_lumber
slummer113711203s_lummer
slump94816633s_lump__
slumps104313583s_lump_s
slurred8359193s_lurred
slushed113611243s_lushed
souped95017673s_ou_ped
splurged1243923splurged
spumed114711543s_pum_ed
stamped124812813s_tamped
stomped124110533s_tomped
strummed1344473strummed
strumpet1256033strumpet
stummed12348553s_tummed
stumper113610093s_tumper
summed114014043s__ummed
supped114415703s__upped
swamped15498443s_wamped
syruped1334543syru_ped
thrummed1642843thrummed
thumbed15336173th_umbed
thumper14356953th_umper
trumped12439713_trumped
tumped114216233__tumped
umped104717273___umped
volumed13285683volum_ed
whomped18345473wh_omped
whupped18365413wh_upped

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 Limit1461621267.36019859.0
3Display Results1261260.0462739.1
 (SQL Overall)1786911267.82922824.2
 
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.