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

187 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
hashish123835(None) 
aspish114810332_aspish
bakshish2043742bakshish
dashis104414392dashis_
hagfish17227612hagfish
haggish15207472haggish
haimish1537752haimish
hasheesh1342592hasheesh
hashes125024802hashes_
hashing145020162hashing
hashishes1444392hashishes
hawkish2036552hawkish
raspish1298102raspish
waspish1586922waspish
aguish1059283_aguish
ahis76135383_a_his_
aphis105917133_aphis_
apish105116643_a_pish
ashes86230613_ashes_
ashier94714833_ashier
ashiest10313963_ashiest
ashing107824093_ashing
aslosh966233_aslosh
aspis74618143_aspis_
assist6314603_assist
babyish1736513babyish
baldish1339503baldish
banish111416063ba_nish
bashes115631393bashes_
bashing135422583bashing
basis75429863bas_is_
bassist9312743bassist
batfish1558683batfish
brassish1346433brassish
caddish143810133caddish
carlish12312773carlish
cashes114729883cashes_
cashier123713323cashier
cashing135022553cashing
cassis84818853cassis_
casuist9411303casuist
catfish1559023catfish
cattish12410723cattish
chassis123910663chassis_
chastise1348173chastise
dampish1567663dampish
danish101513813da_nish
darkish1537943darkish
dashes106124983dashes_
dashi95013113dashi__
dashier114311183dashier
dashiest12311123dashiest
dashiki1544203dashiki
dashing125917893dashing
duskish1535183duskish
faddish15359003faddish
fairish1338993fairish
famish14311853fa_mish
fascism1436443fascism
fascist1239213fascist
fashes124524023fashes_
fashing144918793fashing
fashion1337843fashion
fattish1359263fattish
garfish14179203garfish
garish104516933ga_rish
garnish111610853garnish
gashes105725153gashes_
gashest114813413gashest
gashing125119233gashing
gawkish1835833gawkish
hadith13312063ha_dith
hadjis17439653hadjis_
hagbush1642623hagbush
haggis11209513haggis_
hahas117118443ha_has_
hahs108333363ha_h_s_
hajis156716283ha_jis_
hajjis15485893hajjis_
harpist12312363harpist
harsh116418053ha__rsh
harshest14310193harshest
hash106936503ha___sh
hashed136021943hash_ed
hasping134414903hasping
hasps105114643has_ps_
hassium1236133hassium
hastes95727073hastes_
hastier103916623hastier
hastiest112916503hastiest
hastily133010663hastily
hasting114725193hasting
headfish1845443headfish
heimish1535463heimish
hellish13310723hellish
hennish1336863hennish
hickish1936473hickish
hippish1736183hippish
hogfish17257023hogfish
hoggish15247593hoggish
hottish13117903hottish
huffish1935713huffish
hunnish1336163hunnish
hushes124718593hushes_
hushing144514473hushing
jadish17319913ja_dish
kaddish16317973kaddish
kashas133311913kashas_
laddish12299723laddish
ladyish14287823ladyish
largish1138603largish
larkish1439083larkish
lashes94831003lashes_
lashing114422893lashing
lashins103915153lashins
lassis65216703lassis_
lathis95516173lathis_
latish92416183la_tish
lavish124112993la_vish
lazyish22265853lazyish
maddish14289483maddish
maidish13239553maidish
mannish121710703mannish
marish114319063ma_rish
mashes115030003mashes_
mashgiah1742923mashgiah
mashie11315933mashi_e
mashies12318253mashies
mashing134422243mashing
mawkish1935823mawkish
oafish121311733oa_fish
oarfish13158613oarfish
oasis56422553oas_is_
pachisi14329523pachisi
palish114718283pa_lish
panfish15229983panfish
parish115022363pa_rish
pashas115117063pashas_
pashes115828393pashes_
pashing135120513pashing
pastis84924323pastis_
phasis114614923phas_is_
rachis114017653rachis_
radish103516923ra_dish
raffish1658843raffish
rakish134313973ra_kish
rammish1437563rammish
rankish14510393rankish
raphis114014323raphis_
rashes95330153rashes_
rashest103916873rashest
ratfish1338773ratfish
rattish10510823rattish
ravish123414043ra_vish
rawish123012923ra_wish
rhachis1555693rhachis_
rishis9312453rishis_
roshis9311793roshis_
saltish10312163saltish
sashes94728483sashes_
sashimi1244643sashimi
sashing114621473sashing
sawfish1637683sawfish
shist84829613__shist
shush113812543__shush
sushis9311183sushis_
swish115114823__swish
tachism1478873tachism
tachist12613293tachist
tallish103313583tallish
tannish101610583tannish
tarnish101611883tarnish
tartish101512633tartish
vampish1766293vampish
vanish121513233va_nish
varnish13169553varnish
waggish15207073waggish
waifish1637703waifish
wampish1777293wampish
warmish1538373warmish
washes124425493washes_
washier133611153washier
washiest14310413washiest
washing145119283washing
whish144512923__whish
wispish1575643wispish
zanyish2235913zanyish

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.420425454.8
2DLD Change Limit1340271876.43620824.6
3Display Results1871870.0802337.5
 (SQL Overall)1786911876.93625762.8
 
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.