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

189 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
hottish1311790(None) 
sottish10129441sottish
cattish12410722cattish
coltish121310932coltish
doltish11118732doltish
fattish1359262fattish
goatish1139562goatish
hogfish17257022hogfish
hoggish15247592hoggish
hottest10411382hottest
hottie92514382hotti_e
hotties103016962hotties
hotting113116522hotting
loutish1039962loutish
pettish1238282pettish
rattish10510822rattish
ruttish1048302ruttish
shortish1437422shortish
softish13127812softish
wettish1335962wettish
batfish1558683batfish
boarish123911913boarish
boggish14238653boggish
boobish14338943boobish
bookish163610023bookish
boorish123712593boorish
botts75224863bott_s_
boxfish2285543boxfish
boyish142911233bo_yish
brattish1346973brattish
brutish1237703brutish
catfish1559023catfish
chotts113610993chott_s_
coatis85122603coatis_
cockish1838503cockish
codfish1637163codfish
coldish1399303coldish
coolish12312523coolish
cottas84615573cottas_
cottier93814173cottier
cowfish1836433cowfish
coyish143710393co_yish
cultish12139113cultish
dhootis1135683dhootis_
dhotis1038973dho_tis_
dogfish15226763dogfish
doggish13237533doggish
dollish11610093dollish
donnish11187633donnish
dottier83910923dottier
dottiest92611393dottiest
dottily1147283dottily
dotting93314483dotting
dovish1338103do_vish
fetish12310373_fetish
flattish1455263flattish
fogyish1735363fogyish
folkish1736563folkish
foolish1339613foolish
foppish1735103foppish
fortis95418613fortis_
fortyish1744843fortyish
foxfish2354483foxfish
ghoulish1543543ghoulish
glottis837173glottis_
goatfish1544293goatfish
goodish1237963goodish
goyish13379013go_yish
hagfish17227613hagfish
haggish15207473haggish
haimish1537753haimish
hashish1238353hashish
hatting113920233hatting
hawkish2036553hawkish
heimish1535463heimish
hellish13310723hellish
hennish1336863hennish
hickish1936473hickish
hippish1736183hippish
hitting113017273hitting
hoboism1446623hoboism
hogtie102711773hogti_e
hogtied12226653hogtied
hogties112813993hogties
hogwash1742713hogwash
hoise85224773ho__ise
hoist86433213ho__ist
holism113713753ho_lism
holist94723213ho_list
holts85627913holt_s_
hootch14386413hoot_ch
hootier104915353hootier
hootiest113115643hootiest
hooting113919883hooting
hoots84830253hoot_s_
hornist102314823hornist
hostas94515833hostas_
hostess103210243hostess
hostile10312553hostile
hosting114318383hosting
hosts85526703host_s_
hotch136214733ho_t_ch
hotels94515523hotels_
hotline10712353hotline
hotlink1476763hotlink
hotness1038613hotness
hots78349333ho_t_s_
hotted104319943hott_ed
hotter94720083hott_er
houris94514583houris_
huffish1935713huffish
hunnish1336163hunnish
hutting113016033hutting
jotting152912773jotting
latish92416173_latish
leftish13197253leftish
littlish1145043littlish
loggish12258733loggish
longish11229093longish
lottes65322753lottes_
lotting82917753lotting
lottos64613103lottos_
loudish1137983loudish
lowish12310533lo_wish
mobbish1635923mobbish
modish123813543mo_dish
monish114217593mo_nish
monkish1638243monkish
moonish123311043moonish
moorish123311783moorish
mopish134311593mo_pish
mortise9713533mortise
mottes85523693mottes_
mottos84615243mottos_
motts76527003mott_s_
noirish1037883noirish
nourish1039703nourish
oafish121311723_oafish
oddish11107653_oddish
offish15137273_offish
ogrish1039263_ogrish
oldish10169313_oldish
otitis63612343_otitis_
ottos54714323_ottos_
outfish132210573outfish
outwish13289853outwish
owlish1238703_owlish
poetise9314043poetise
polish114916723po_lish
poorish123712303poorish
popish133812113po_pish
potash1138273po_tash
pottier93516493pottier
potties93723543potties
pottiest102815973pottiest
potting103720893potting
pottos84615873pottos_
ratfish1338773ratfish
roguish1156833roguish
rompish1436693rompish
rotis56327063ro_tis_
rottes64524833rottes_
rotting82919683rotting
runtish1048693runtish
saltish10312163saltish
shotting123012383shotting
shotts93614703shott_s_
skittish1544503skittish
sluttish1145443sluttish
snoutish1145783snoutish
sottishly1543763sottishly
sourish10310693sourish
stonish10410653stonish
stoutish1145903stoutish
tartish101512633tartish
toadish1139063toadish
tonish93415903to_nish
tonnish10149093tonnish
totting82816843totting
townish13167933townish
toyish122911123to_yish
tuttis63611373tuttis_
voguish1465203voguish
whitish1635973whitish
whorish1636603who_rish
woggish15276673woggish
wolfish1636933wolfish
wormish1537163wormish
wotting112913843wotting

Search took 8 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 Limit1340271897.01319111.2
3Display Results1891890.0633000.0
 (SQL Overall)1786911897.49923828.6
 
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.