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

174 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
fishiness153734(None) 
ashiness1138962_ashiness
bushiness14177762bushiness
cushiness14197182cushiness
feistiness1345072feistiness
fieriness1238622fieriness
filminess1435982filminess
filthiness1643712filthiness
fishiest14310452fishi_est
fishinesses17107242fishinesses
fishings15307692fishin_gs
fishless1436412fish_less
fishlines15246842fishline_s
fishnets1445632fish_nets
flashiness16105282flashiness
fleshiness16104292fleshiness
friskiness1744452friskiness
fussiness12226582fussiness
fustiness121910242fustiness
gushiness13206852gushiness
mistiness111911632mistiness
mushiness14248222mushiness
pithiness1437562pithiness
pushiness14197282pushiness
riskiness1336962riskiness
sissiness8217962sissiness
washiness1537042washiness
wispiness1435632wispiness
achiness1339703_achiness
airiness8412213ai_riness
apishness1445743apish_ness
bitchiness1743793bitchiness
bittiness11228333bittiness
boskiness15196513boskiness
bossiness11257423bossiness
business102110693bus_iness
bustiness111810473bustiness
cosiness103214283cos_iness
crispiness1444793crispiness
dinginess1137823dinginess
dippiness1435973dippiness
dirtiness1039473dirtiness
dishiest12313683dishi_est
dishonest13410773dishonest
ditsiness1048143ditsiness
ditziness1945883ditziness
dizziness1834183dizziness
duskiness14216683duskiness
dustiness102211033dustiness
easiness8313043eas_iness
fanciness1437673fanciness
fascines13310143fascine_s
fashioners16123963fashioners
fastness11238763fas_tness
fattiness12239373fattiness
fineness11310643fi_neness
firmness1334743fi_rmness
firstness1245013firstness
fishbones1744263fishbone_s
fishers134714723fish__ers
fishes125221343fish__e_s
fisheyes1744093fisheye_s
fishier13359853fishi_e_r
fishing143913863fishin__g
fishline14237583fishline__
fishnet13410343fish_ne_t
fishwives2142173fishwive_s
fissipeds1542423fissipeds
fitness10299393fi__tness
fixedness2043713fixedness
flakiness1636473flakiness
flightiness1843893flightiness
flimsiness1543453flimsiness
flintiness1345893flintiness
flukiness1635453flukiness
flushness1544893flush_ness
foaminess1437503foaminess
fogginess1434973fogginess
forkiness16268703forkiness
foxiness18257403f_oxiness
foziness20257803f_oziness
freshness1545943fresh_ness
frizziness2142713frizziness
frostiness1336563frostiness
frothiness1645723frothiness
funkiness16226873funkiness
funniness12256533funniness
furriness12287603furriness
fuzziness2033173fuzziness
gassiness10268313gassiness
giddiness1234683giddiness
grisliness1155143grisliness
gustiness10189893gustiness
hastiness122410883hastiness
highness1536053high_ness
hilliness1248923hilliness
hippiness1635463hippiness
huskiness16206583huskiness
iciness938863_i_ciness
ickiness1436753_ickiness
iffiness1435023_iffiness
inkiness1238693_inkiness
itchiness1444753itchiness
kinkiness1235763kinkiness
lightness13107433lightness
liminess10510643li_miness
lippiness1335413lippiness
litheness1247363litheness
lushness1136233lush_ness
lustiness92010453lustiness
marshiness1555063marshiness
massiness112810143massiness
messiness11248223messiness
miffiness1734523miffiness
mightiness1645093mightiness
milkiness1536523milkiness
miriness10310463mi_riness
mossiness11258323mossiness
muskiness15237443muskiness
mussiness11238303mussiness
mustiness112211663mustiness
nastiness92310573nastiness
niftiness1236363niftiness
nighness1236103nigh_ness
nippiness1334713nippiness
noisiness948343nois_iness
nosiness83211393nos_iness
oafishness1644463oafish_ness
offishness1943793offish_ness
oiliness8311563oi_liness
pastiness112312353pastiness
peskiness15216523peskiness
pickiness1737623pickiness
pigginess1375453pigginess
pipiness1238003pi_piness
pixiness1736093pi_xiness
plushiness1544093plushiness
poshness1356653posh_ness
prissiness1266133prissiness
rashness1138093rash_ness
raspiness1137303raspiness
reshines112615443reshine_s
richness1337433rich_ness
rightness13117353rightness
riminess10510093ri_miness
ritziness1835823ritziness
rosiness82613173ros_iness
rustiness92111933rustiness
sassiness8249333sassiness
shiners104015943__shiners
shines95028913__shine_s
shyness1344993__shyness
silkiness1337253silkiness
silliness9510363silliness
sissyness11252963sissyness
siziness1737423si_ziness
slushiness1344643slushiness
squishiness2342983squishiness
tastiness92311143tastiness
testiness9209753testiness
tidiness938793ti_diness
tightness1386603tightness
tininess8310633ti_niness
tinniness936093tinniness
tipsiness1135703tipsiness
trashiness1346443trashiness
waspiness1435793waspiness
wiliness1139113wi_liness
wimpiness1635293wimpiness
windiness1337373windiness
wiriness1138953wi_riness
wiseness112010753wis_eness
wishless1435993wish_less
wittiness12197223wittiness

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411746.29623608.8
3Display Results1741740.0802175.0
 (SQL Overall)1786911746.79626293.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.