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

177 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
hagfish1722761(None) 
haggish15207471haggish
hogfish17257021hogfish
aguish1059282_aguish
batfish1558682batfish
catfish1559022catfish
dogfish15226762dogfish
garfish14179202garfish
hagbush1642622hagbush
hagfishes1945152hagfishes
haggis11209512haggis_
haimish1537752haimish
hashish1238352hashish
hawkish2036552hawkish
headfish1845442headfish
hoggish15247592hoggish
huffish1935712huffish
oafish121311722oa_fish
oarfish13158612oarfish
panfish15229972panfish
pigfish16217172pigfish
raffish1658842raffish
ratfish1338772ratfish
sawfish1637682sawfish
waggish15207072waggish
waifish1637702waifish
ageism968803_ageism
ageist7315383_ageist
agism84614063_ag_ism
agist66325583_ag_ist
anguish11117633anguish
apish105116633_a_pish
aspish114810333_aspish
babyish1736513babyish
baitfish1645483baitfish
baldish1339503baldish
banish111416043ba_nish
biggish14247503biggish
boarfish1635753boarfish
boggish14238653boggish
boxfish2285543boxfish
caddish143810123caddish
carlish12312763carlish
cattish12410723cattish
cavefish1974853cavefish
coalfish1635493coalfish
codfish1637163codfish
cowfish1836433cowfish
crawfish1944233crawfish
crayfish1944253crayfish
dampish1567663dampish
danish101513793da_nish
darkish1537943darkish
deafish1438533deafish
dealfish1545503dealfish
doggish13237533doggish
draffish1844553draffish
dwarfish1843783dwarfish
elfish1267963_elfish
english1137953english
faddish15359003faddish
fairish1338993fairish
fallfish1744463fallfish
famish14311843fa_mish
fattish1359263fattish
finfish16268193finfish
fish106926273___fish
flatfish1744933flatfish
fogyish1735363fogyish
foxfish2354483foxfish
frogfish1843943frogfish
garish104516923ga_rish
garnish111610843garnish
gawkish1835833gawkish
goatfish1544293goatfish
grayfish1844483grayfish
haafs115711163haaf_s_
hadith13312063ha_dith
hadjis17439643hadjis_
haffit1538533haffi_t
haffits1636193haffits
hafiz20611213ha_fi_z
hafts116219463ha_fts_
hagadist1347603hagadist
hagging133114683hagging
haggises1335883haggises
haggishly2042913haggishly
hagride1237553hagride
hags86740843hag__s_
hajis156716273ha_jis_
hajjis15485883hajjis_
hangfire1543763hangfire
harpist12312353harpist
harsh116418053ha__rsh
hash106936503ha___sh
hawfinch2242033hawfinch
heimish1535463heimish
hellish13310723hellish
hennish1336863hennish
hickish1936473hickish
hippish1736183hippish
hogfishes1944683hogfishes
hogwash1742703hogwash
hottish13117893hottish
hunnish1336163hunnish
hygeist1445793hygeist
jackfish2744123jackfish
jadish17319903ja_dish
jewfish2343543jewfish
jiggish19225943jiggish
kaddish16317973kaddish
kingfish1944483kingfish
laddish12299723laddish
ladyfish1843803ladyfish
ladyish14287823ladyish
languish12136253languish
largish1138603largish
larkish1439083larkish
latish92416173la_tish
lavish124112983la_vish
lazyish22265853lazyish
loggish12258723loggish
lungfish1543963lungfish
maddish14289483maddish
maidish13239553maidish
mannish121710693mannish
marish114319053ma_rish
mawkish1935823mawkish
mudfish1646263mudfish
offish15137273_offish
ogrish1039263_ogrish
outfish132210573outfish
paganish1447773paganish
palish114718273pa_lish
parish115022353pa_rish
piggish14227703piggish
pinfish15319303pinfish
puggish14265993puggish
pupfish1735533pupfish
radish103516913ra_dish
ragis66325603rag_is_
rakish134313963ra_kish
rammish1437563rammish
rankish14510383rankish
raspish1298103raspish
rattish10510823rattish
ravish123414033ra_vish
rawish123012913ra_wish
redfish1437793redfish
roguish1156833roguish
sailfish1446053sailfish
saltish10312163saltish
sandfish1556683sandfish
selfish1388513selfish
serfish1348973serfish
sheatfish1843243sheatfish
starfish1438083starfish
sunfish1338883sunfish
tallish103313583tallish
tannish101610573tannish
tarnish101611873tarnish
tartish101512633tartish
thuggish1642643thuggish
tigrish1137563tigrish
toadfish1544903toadfish
vampish1766283vampish
vanish121513203va_nish
varnish13169533varnish
voguish1465203voguish
wampish1777293wampish
warmish1538373warmish
waspish1586923waspish
weakfish2143523weakfish
woggish15276673woggish
wolfish1636933wolfish
yagis95416573yag_is_
zanyish2235903zanyish

Search took 10 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 Limit1340271779.40614249.1
3Display Results1771770.0632809.5
 (SQL Overall)1786911779.62518565.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.