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

139 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
mudfish164626(None) 
codfish1637162codfish
dudish1148312dud_ish
huffish1935712huffish
maddish14289482maddish
modish123813542mod_ish
mudfishes1844192mudfishes
mulish11311902mu_lish
outfish132210572outfish
pupfish1735532pupfish
redfish1437792redfish
studfish1544522studfish
sunfish1338882sunfish
batfish1558683batfish
bluefish1645143bluefish
boxfish2285543boxfish
buckish18237883buckish
bullish12511193bullish
burnish1238623burnish
caddish143810133caddish
catfish1559023catfish
cowfish1836433cowfish
cubbish1635803cubbish
cuish10313173cu__ish
cultish12139113cultish
currish1238353currish
deafish1438533deafish
dish86328343__d_ish
dogfish15226763dogfish
drumfish1743503drumfish
dullish1148743dullish
dumpish15116113dumpish
duncish1335793duncish
duskish1535183duskish
elfish1267963_elfish
faddish15359003faddish
finfish16268193finfish
fish106926283___fish
foxfish2354483foxfish
furbish1536443furbish
furnish1337383furnish
garfish14179203garfish
goldfish1644203goldfish
gruffish1843943gruffish
hagfish17227613hagfish
headfish1845443headfish
hogfish17257023hogfish
hunnish1336163hunnish
jadish17319913jad_ish
jewfish2343543jewfish
judoist1545633judoist
kaddish16317973kaddish
kiddish16276583kiddish
kufis1249253ku_fis_
laddish12299723laddish
ladyfish1843803ladyfish
ladyish14287823ladyish
loudish1137983loud_ish
lumpfish1843053lumpfish
lumpish14127383lumpish
lungfish1543963lungfish
lutfisk1443583lutfisk
maidish13239553maidish
mannish121710703mannish
marish114319063m_arish
mawkish1935823mawkish
midis85923423mid_is_
midlist10312513midlist
midrash1335423midrash
milkfish2043333milkfish
minish115216313m_inish
minxish1936213minxish
mobbish1635923mobbish
monish114217603m_onish
monkfish2044003monkfish
monkish1638243monkish
moonfish1675333moonfish
moonish123311043moonish
moorish123311783moorish
mopish134311593m_opish
muddied12339213muddied
muddier114110023muddier
muddies113513953muddies
muddiest12298733muddiest
muddily1435963muddily
mudding123310813mudding
mudflap1542183mudflap
mudflat1364883mudflat
mudflow1642343mudflow
mudras94212263mudras_
muds75530663mud__s_
mudsill1045163mudsill
muffin14298873muffi_n
muffing163210403muffing
muffins15308343muffins
muffs134114213mu_ffs_
muftis1158053muftis_
munis75022003mu_nis_
mush94929123mu___sh
mutism103211463mu_tism
nudism9357913nud_ism
nudist73813323nud_ist
numbfish1842603numbfish
nunnish1035933nunnish
oafish121311733_oafish
oarfish13158613oarfish
oddish11107653_oddish
offish15137273_offish
oldish10169313old_ish
outwish13289853outwish
panfish15229983panfish
pigfish16217173pigfish
pinfish15319303pinfish
prudish1376563prud_ish
publish1447913publish
puckish18237213puckish
puggish14265993puggish
punish111411513pu_nish
punkish16257693punkish
radish103516923rad_ish
raffish1658843raffish
ratfish1338773ratfish
reddish1238033reddish
rubbish1436303rubbish
runtish1048693runtish
ruttish1048303ruttish
sandfish1556683sandfish
sawfish1637683sawfish
selfish1388513selfish
serfish1348973serfish
suckfish2043893suckfish
surffish1744783surffish
toadfish1544903toadfish
tundish1137283tundish
unwish1239093_unwish
uppish1336633_uppish
waifish1637703waifish
widish13419363wid_ish
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.423422437.4
2DLD Change Limit1340271396.23321502.8
3Display Results1391390.0632206.3
 (SQL Overall)1786911396.71926594.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.