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 “shlumpy” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
shlumpy174286(None) 
schlumpy2041871schlumpy
shlump1345711shlump_
shlumps1434141shlumps
clumpy15409572_clumpy
glumpy14527192_glumpy
humpy155115672_h_umpy
lumpy126615912__lumpy
schlump1643262schlump_
schlumps1742742schlumps
shlumped1643442shlumped
shrimpy17415402shrimpy
slummy13325862s_lummy
slump94816632s_lump_
slumps104313582s_lumps
stumpy13458132s_tumpy
bumpy144715053__bumpy
calumny1443863calumny
champy18509613ch_ampy
chummy18385893ch_ummy
chump145315443ch_ump_
chumps154313823ch_umps
clump115517453_clump_
clumps1215314643_clumps
clumsy13326193_clumsy
dumpy135414753__dumpy
flump124614723_flump_
flumps135112503_flumps
frumpy16466883_frumpy
galumph15102663galumph
glumly12356623_glumly
grumpy14498153_grumpy
hempy154912763_h_empy
hump116228723_h_ump_
humph155712213_h_umph
humps126322803_h_umps
jumpy195712813__jumpy
lump86531703__lump_
lumps95624983__lumps
plummy15375663_plummy
plump115315263_plump_
plumply1634223_plumply
plumps124612613_plumps
plumy124213233_plum_y
rheumy1433353rheum_y
schlumped1941953schlumped
scrimpy16486133scrimpy
scummy15265223s_cummy
shammy16388503sh_ammy
shamoy14379913sh_amoy
sharpy145211033sh_arpy
shimmy16306413sh_immy
shlep104914833shl_ep_
shlepp13366193shl_epp
shlepps14394833shlepps
shleps114710333shl_eps
shlocky19314503shlocky
shlub105411743shlu__b
shlubs11386733shlu_bs
shlumping1733373shlumping
shrimp13478773shrimp_
shrimps14516753shrimps
shrubby1742363shrubby
sirupy11377053siru_py
skimpy17475723s_kimpy
sleepy11479413s_leepy
slimly11408903s_limly
slimpsy1463333s_limpsy
slimsy11407723s_limsy
slimy105417423s_lim_y
slippy1375843s_lippy
sloppy1395303s_loppy
sludgy11366253s_ludgy
sluicy1166483s_luicy
slum65430513s_lum__
slumped123710153s_lumped
slums74623433s_lum_s
slurp74014983s_lurp_
slurps84410003s_lurps
slurry9378603s_lurry
slushy12417223s_lushy
slutty9248003s_lutty
solubly1255283solubly
solum74717613solum__
solums85211333solum_s
soupy106115403s_ou_py
splurgy1343023splurgy
spumy124610363s_pum_y
stump94616463s_tump_
stumps104912283s_tumps
sump86331533s__ump_
sumps95023433s__umps
swampy16437233s_wampy
syrupy14285823syru_py
thrummy1742173thrummy
thump126211573th_ump_
thumps13449353th_umps
whump154910043wh_ump_
whumps16427093wh_umps

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.453394461.4
2DLD Change Limit134027996.94019312.2
3Display Results99990.0303300.0
 (SQL Overall)178691997.42324072.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.