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

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

54 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
blimpishnesses238214(None) 
blimpishness2172072blimpishne_s_s
impishnesses1944292__impishnesses
lumpishnesses2043472_lumpishnesses
wimpishnesses2343582_wimpishnesses
bluishnesses1765263bl__uishnesses
cliquishnesses2852113cliquishnesses
limpidnesses1743623_limpi_dnesses
apishnesses1646374___apishnesses
bearishnesses1844844b_earishnesses
bookishnesses2263684b_ookishnesses
boorishnesses1864314b_oorishnesses
boyishnesses2044034b__oyishnesses
brackishnesses2552644brackishnesses
brutishnesses1844094b_rutishnesses
bullishnesses1844044b_ullishnesses
bumpinesses17126374b_umpi__nesses
childishnesses2352564childishnesses
clannishnesses1952984clannishnesses
cloddishnesses2152624cloddishnesses
clownishnesses2262274clownishnesses
faintishnesses2053304faintishnesses
flimsinesses1743994flim__sinesses
foppishnesses2343394_foppishnesses
girlishnesses1744034_girlishnesses
impishness1744124__impishne_s_s
lavishnesses1844774_l_avishnesses
liminesses121310854_lim_i__nesses
limpnesses14116654_limp___nesses
lippinesses1535514_lippi__nesses
liverishnesses2063024_liverishnesses
loutishnesses1644994_loutishnesses
lumpinesses15107114_lumpi__nesses
lumpishness1843154_lumpishne_s_s
piggishnesses2043284_piggishnesses
pinkishnesses2243984_pinkishnesses
priggishnesses2152374priggishnesses
sheepishnesses2153014sheepishnesses
sickishnesses2143664_sickishnesses
skimpinesses2043184skimpi__nesses
skittishnesses2052394skittishnesses
slavishnesses1843684sl_avishnesses
sliminesses1338094slim_i__nesses
sluggishnesses1852144sluggishnesses
sluttishnesses1652684sluttishnesses
snappishnesses2052264snappishnesses
sniffishnesses2272204sniffishnesses
swinishnesses1843654swi_nishnesses
thievishnesses2362194thievishnesses
trickishnesses2352504trickishnesses
uppishnesses1943604__uppishnesses
waspishnesses2043284_waspishnesses
wimpinesses1835634_wimpi__nesses
wimpishness2143214_wimpishne_s_s

Search took 4 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 Filter178691658740.0931921408.6
2DLD Change Limit65874542.93622436.6
3Display Results54540.0331636.4
 (SQL Overall)178691543.06258357.6
 
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.