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 “mudpack” 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
mudpack184359(None) 
mudpacks1943231mudpacks
manpack1746062manpack
mudlark1463912mudlark
mudrock1644352mudrock
unpack1457832_unpack
bipack1636523_bipack
buyback2045533buyback
calpack17338333calpack
cutback1747093cutback
hardpack2043923hardpack
humpback2343593humpback
mack125733653m___ack
mediacy1536143mediacy
medick154010133med_ick
midspace1543953midspace
muck125727853mu___ck
mudcap1335133mudca_p
mudcaps1444103mudcaps
mudcat11311203mudca_t
mudcats1236223mudcats
mudlarks1542883mudlarks
mudra83912433mudra__
mudras94212253mudra_s
mudrocks1743993mudrocks
mullock1535713mullock
multipack1944643multipack
musick14408703mu_sick
nudnick1452863nudnick
nutpick1543883nutpick
outback15310653outback
outpace112613023outpace
pack125535443___pack
prepack1757643prepack
quack203812503qu__ack
repack142412163_repack
ruddock1543133ruddock
runback1556603runback
sunback1548153sunback
tripack1565673tripack
umiack1435173_umiack
unpacks1576093_unpacks
unpick1446903_unpick
untack1239763_untack

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 Filter1786911340270.1561145455.1
2DLD Change Limit134027446.56320421.6
3Display Results44440.0162750.0
 (SQL Overall)178691446.73526531.7
 
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.