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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

108 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
huffinesses203412(None) 
puffinesses1934511puffinesses
daffinesses1834842daffinesses
fluffinesses1742662fluffinesses
heftinesses1737132heftinesses
huffiness1844282huffine_s_s
humpinesses18106242humpinesses
huskinesses18136532huskinesses
iffinesses1635582_iffinesses
miffinesses1944362miffinesses
stuffinesses1843292stuffinesses
beefinesses1675953beefinesses
bluffnesses1942773bluff_nesses
bugginesses1545373bugginesses
bulginesses1466133bulginesses
bulkinesses1786483bulkinesses
bumpinesses17126373bumpinesses
burlinesses1338403burlinesses
bushinesses16107463bushinesses
businesses121411373bu_sinesses
bustinesses131310093bustinesses
chubbinesses2142603chubbinesses
chumminesses2142863chumminesses
comfinesses1846913comfinesses
curlinesses1338733curlinesses
cushinesses16127413cushinesses
dumpinesses16126253dumpinesses
duskinesses16136843duskinesses
dustinesses121110353dustinesses
finesses111912343___finesses
funkinesses18137003funkinesses
funninesses14106873funninesses
furrinesses1437183furrinesses
fussinesses13126943fussinesses
fustinesses14129783fustinesses
fuzzinesses2243723fuzzinesses
goofinesses1535963goofinesses
gruffnesses1842923gruff_nesses
gumminesses1634933gumminesses
gushinesses15127023gushinesses
gustinesses12139523gustinesses
gutsinesses12128153gutsinesses
hairinesses14198943hairinesses
halfnesses1636263half_nesses
hamminesses1835773hamminesses
handinesses151410273handinesses
happinesses1876163happinesses
hardinesses151110213hardinesses
hastinesses141210693hastinesses
hazinesses2239223h_azinesses
headinesses1539843headinesses
heavinesses1747453heavinesses
hillinesses1458503hillinesses
hippinesses1845493hippinesses
hoarinesses14310223hoarinesses
hokinesses1758943h_okinesses
holinesses13511493h_olinesses
hominesses15510863h_ominesses
horninesses1459003horninesses
horsinesses1439553horsinesses
hugenesses1437143hu_genesses
humannesses1643863humannesses
humidnesses1744583humidnesses
hungrinesses1643853hungrinesses
juicinesses2035893juicinesses
jumpinesses22125343jumpinesses
leafinesses1437873leafinesses
loftinesses1437923loftinesses
luckinesses1746653luckinesses
lumpinesses15107113lumpinesses
lustinesses11910423lustinesses
muddinesses1535273muddinesses
mugginesses1544923mugginesses
murkinesses17136783murkinesses
mushinesses16127323mushinesses
muskinesses17127043muskinesses
mussinesses12147443mussinesses
mustinesses131010413mustinesses
muzzinesses2133653muzzinesses
niftinesses1437243niftinesses
nubbinesses1544293nubbinesses
nuttinesses11117753nuttinesses
pudginesses1545053pudginesses
puffiness1764363puffine_s_s
pugginesses1545253pugginesses
pulpinesses1536003pulpinesses
puninesses121110753pu_ninesses
punkinesses17127223punkinesses
pursinesses1338743pursinesses
pushinesses1697333pushinesses
quakinesses2436323quakinesses
ruddinesses1336033ruddinesses
runninesses11137693runninesses
runtinesses111210963runtinesses
rustinesses11911553rustinesses
ruttinesses11128993ruttinesses
scruffinesses2151563scruffinesses
shiftinesses18105243shiftinesses
sniffinesses1843693sniffinesses
spiffinesses2043013spiffinesses
sulkinesses1557723sulkinesses
sunninesses11148383sunninesses
surlinesses11310053surlinesses
tubbinesses1544383tubbinesses
uglinesses1138543_uglinesses
unfitnesses1446133_unfitnesses
yuckinesses2044763yuckinesses
yumminesses1843873yumminesses

Search took 6 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 Filter1786911216330.420425454.8
2DLD Change Limit1216331084.97024473.4
3Display Results1081080.0631714.3
 (SQL Overall)1786911085.45332769.3
 
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.