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

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

63 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
rumpled12381001(None) 
crumpled15296871crumpled
rimpled123311421rimpled
rumbled124514591rumbled
rumple103913011rumple_
rumples113313131rumples
bumbled144113042bumbled
bumped134414002bump_ed
crimpled15366932crimpled
crumbled15357442crumbled
crumped144311222crump_ed
crumple13368362crumple_
crumples14348812crumples
dimpled132810302dimpled
drumbled14266032drumbled
dumped123814492dump_ed
fumbled153710492fumbled
grumbled14256752grumbled
grumped13337332grump_ed
humbled153711812humbled
humped144015242hump_ed
humphed1835422humphed
impled113812502_impled
jumbled19379962jumbled
jumped183511552jump_ed
lumped114216962lump_ed
mumbled143010762mumbled
mumped133813162mump_ed
pimpled14289182pimpled
pumped133915562pump_ed
purpled12299752purpled
rambled123913512rambled
ramped114617902ramp_ed
repled93319772r_epled
rimple103814582rimple_
rimples113114222rimples
rippled123110272rippled
romped114513652romp_ed
rubbled124611622rubbled
ruckled144111032ruckled
ruddled103010872ruddled
ruffled14369152ruffled
ruled65822522ru__led
rumbaed12287492rumbaed
rumble103718812rumble_
rumbler113514112rumbler
rumbles114018392rumbles
rumored1046642rumored
rumpless12256542rumpless
rumplier1235302rumplier
rumply13348572rumpl_y
runkled12399012runkled
rustled83311322rustled
sampled123410782sampled
suppled1248462suppled
templed12278552templed
trampled13247902trampled
trumped12439712trump_ed
tumbled123412242tumbled
tumped114216232tump_ed
umped104717272_ump_ed
unrumpled1443672unrumpled
wimpled15338822wimpled

Search took 7 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 Filter1786911076710.190940478.9
2DLD Change Limit107671635.76318683.2
3Display Results63630.0331909.1
 (SQL Overall)178691635.98629851.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.