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

148 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
huffish193571(None) 
gruffish1843942gruffish
hagfish17227612hagfish
hogfish17257022hogfish
huffier1637492huffier
huffiest1757202huffiest
huffily1934692huffily
huffing17278832huffing
huffishly2442612huffishly
huffs144514742huff_s_
hunnish1336162hunnish
mudfish1646262mudfish
offish15137272_offish
outfish132210572outfish
pupfish1735532pupfish
raffish1658842raffish
sunfish1338882sunfish
surffish1744782surffish
batfish1558683batfish
bluefish1645143bluefish
boxfish2285543boxfish
buckish18237883buckish
buffest15298643buffest
buffi136112203buffi__
buffier1568403buffier
buffiest1657563buffiest
buffing163411393buffing
buffos14447853buffos_
buffs135519513buff_s_
bullish12511193bullish
burnish1238623burnish
catfish1559023catfish
chuffest1944193chuffest
chuffier1934543chuffier
chuffiest2044403chuffiest
chuffing2055043chuffing
chuffs17427783chuff_s_
churlish1644903churlish
codfish1637163codfish
cowfish1836433cowfish
cubbish1635803cubbish
cuffing163210253cuffing
cuffs135017493cuff_s_
cuish10313173cu__ish
cultish12139113cultish
currish1238353currish
deafish1438533deafish
dogfish15226763dogfish
draffish1844553draffish
drumfish1743503drumfish
dudish1148313du_dish
duffs125216623duff_s_
dullish1148743dullish
dumpish15116113dumpish
duncish1335793duncish
duskish1535183duskish
elfish1267963_elfish
finfish16268193finfish
fish106926273___fish
foxfish2354483foxfish
furbish1536443furbish
furnish1337383furnish
garfish14179203garfish
guffs124414823guff_s_
haffit1538533haffi_t
haffits1636193haffits
haggish15207473haggish
haimish1537753haimish
hashish1238353hashish
hawkish2036553hawkish
headfish1845443headfish
heimish1535463heimish
hellish13310723hellish
hennish1336863hennish
hickish1936473hickish
hippish1736183hippish
hoggish15247593hoggish
hottish13117903hottish
hubris11218973hubris_
huff135623843huff___
huffed163710153huff_ed
huffiness1844283huffiness
huffy174810233huff__y
hush105224113hu___sh
jewfish2343543jewfish
kufis1249253ku_fis_
leftish13197253leftish
luffas12337483luffas_
luffing143310103luffing
luffs114516283luff_s_
lumpfish1843053lumpfish
lumpish14127383lumpish
lungfish1543963lungfish
lutfisk1443583lutfisk
muffin14298873muffi_n
muffing163210403muffing
muffins15308343muffins
muffs134114213muff_s_
muftis1158053muftis_
mulish11311903mu_lish
numbfish1842603numbfish
nunnish1035933nunnish
oafish121311723_oafish
oarfish13158613oarfish
outwish13289853outwish
panfish15229973panfish
pigfish16217173pigfish
pinfish15319303pinfish
publish1447913publish
puckish18237213puckish
puffier1547973puffier
puffiest1647323puffiest
puffily1834843puffily
puffin141149003puffi_n
puffing162910943puffing
puffins15278913puffins
puffs134114933puff_s_
puggish14265993puggish
punish111411503pu_nish
punkish16257693punkish
ratfish1338773ratfish
redfish1437793redfish
rubbish1436303rubbish
ruffes124112423ruffes_
ruffian1344133ruffian
ruffing143210843ruffing
ruffs114516743ruff_s_
runtish1048693runtish
ruttish1048303ruttish
sawfish1637683sawfish
selfish1388513selfish
serfish1348973serfish
sniffish1744513sniffish
softish13127813softish
stiffish1745243stiffish
studfish1544523studfish
suckfish2043893suckfish
suffice15197573suffice
suffix1935233suffi_x
suffuse1335443suffuse
thuggish1642653thuggish
tuffs115118263tuff_s_
tundish1137283tundish
unwish1239093_unwish
uppish1336633_uppish
waifish1637703waifish
wolffish2043333wolffish
wolfish1636933wolfish

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.390458182.1
2DLD Change Limit1340271486.20321606.8
3Display Results1481480.0463217.4
 (SQL Overall)1786911486.63926915.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.