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

44 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
schlumped194195(None) 
shlumped1643441s_hlumped
chumped17379492_ch_umped
clumped143610662_c_lumped
schlepped1942232schlepped
schlump1643262schlump__
schlumpier1941472schlumpier
schlumps1742742schlump_s
schlumpy2041872schlump_y
slumped123710152s__lumped
champed174111483_ch_amped
chomped17329773_ch_omped
chummed17396443_ch_ummed
clamped144012043_c_lamped
clomped14398973_c_lomped
columned1334923_columned
crumped144311223_c_rumped
flumped15377713__flumped
humped144015243__h_umped
lumped114216963___lumped
plumped14318643__plumped
scalloped1444463scalloped
scalped124411993scal__ped
scamped144711963sc__amped
schemed1577753sch_em_ed
schlemiel1662803schlemiel
schlumpiest2051293schlumpiest
schlumping2041943schlumping
schussed1443053sch_ussed
scolloped1443653scolloped
scrimped1555313sc_rimped
scrummed1554313sc_rummed
sculped12398253sc__ulped
scummed14347913sc__ummed
shlepped1633643s_hlepped
shlump1345713s_hlump__
shlumps1434143s_hlump_s
shlumpy1742863s_hlump_y
shrimped1634213s_hrimped
slummed12359273s__lummed
slurped10368753s__lurped
stumped124210153s__tumped
thumped15387413_th_umped
whumped18335633_wh_umped

Search took 9 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 Filter1786911486410.533335255.2
2DLD Change Limit148641447.68619339.2
3Display Results44440.0162750.0
 (SQL Overall)178691448.23521699.0
 
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.