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 “sniffishnesses” with Change Limit: [1] [2] [3] [4] [5]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

166 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
sniffishnesses227220(None) 
sniffinesses1843692sniffi__nesses
sniffishness2152192sniffishne_s_s
offishnesses2143813__offishnesses
raffishnesses2243223_raffishnesses
selfishnesses1844043s_elfishnesses
sickishnesses2143663s_ickishnesses
skittishnesses2052393skittishnesses
snappishnesses2052263snappishnesses
snobbishnesses2051773snobbishnesses
spiffinesses2043013spiffi__nesses
swinishnesses1843653swi_nishnesses
blimpishnesses2382144blimpishnesses
childishnesses2352564childishnesses
cliquishnesses2852104cliquishnesses
diffusenesses2052824_diffusenesses
dwarfishnesses2492134dwarfishnesses
faintishnesses2053304faintishnesses
girlishnesses1744034_girlishnesses
iffinesses1635574__iffi__nesses
impishnesses1944294__impishnesses
miffinesses1944364_miffi__nesses
niftinesses1437234_nifti__nesses
oafishnesses1844764__oafishnesses
piggishnesses2043284_piggishnesses
pinkishnesses2243984_pinkishnesses
priggishnesses2152374priggishnesses
sheepishnesses2153014sheepishnesses
shiftinesses18105244shifti__nesses
shrewishnesses2262244shrewishnesses
slavishnesses1843674s_lavishnesses
sluggishnesses1852144sluggishnesses
sluttishnesses1652684sluttishnesses
sniffiness1643754sniffi__ne_s_s
sottishnesses1544444s_ottishnesses
squarishnesses2552424squarishnesses
stiffnesses1743594stiff___nesses
stuffinesses1843294stuffi__nesses
stylishnesses1843404s_tylishnesses
swainishnesses1952324swainishnesses
thievishnesses2362194thievishnesses
trickishnesses2352504trickishnesses
unselfishnesses2061514unselfishnesses
wimpishnesses2343584_wimpishnesses
wolfishnesses2243734_wolfishnesses
apishnesses1646375___apishnesses
bearishnesses1844845_bearishnesses
bluishnesses1765235__bluishnesses
bookishnesses2263675_bookishnesses
boorishnesses1864305_boorishnesses
boyishnesses2044035__boyishnesses
brackishnesses2552645brackishnesses
brutishnesses1844085_brutishnesses
bullishnesses1844045_bullishnesses
caddishnesses2043375_caddishnesses
churlishnesses2252545churlishnesses
clannishnesses1952985clannishnesses
cloddishnesses2152615cloddishnesses
clownishnesses2262275clownishnesses
coltishnesses1845215_coltishnesses
cultishnesses1844565_cultishnesses
daffinesses1834845_daffi__nesses
devilishnesses2152695devilishnesses
doggishnesses19143685_doggishnesses
dollishnesses1744375_dollishnesses
doltishnesses1744605_doltishnesses
donnishnesses1784115_donnishnesses
dovishnesses1944465__dovishnesses
faddishnesses2143245_faddishnesses
feverishnesses2382865feverishnesses
fiendishnesses2172475fiendishnesses
fishinesses17107235____fishinesses
fluffinesses1742665fluffi__nesses
flushnesses1745375___flushnesses
folkishnesses2343925_folkishnesses
foolishnesses1944455_foolishnesses
foppishnesses2343395_foppishnesses
freakishnesses2452645freakishnesses
freshnesses1746105___freshnesses
garishnesses1645885__garishnesses
gawkishnesses2443035_gawkishnesses
ghoulishnesses2152285ghoulishnesses
greenishnesses1882965greenishnesses
hawkishnesses2643255_hawkishnesses
hellishnesses1974355_hellishnesses
hoggishnesses21143655_hoggishnesses
huffinesses2034115_huffi__nesses
infinitenesses1795015infinitenesses
initialnesses1395595ini_tialnesses
lavishnesses1844775__lavishnesses
liverishnesses2063015liverishnesses
loutishnesses1644985_loutishnesses
lumpishnesses2043475_lumpishnesses
mannishnesses1873965_mannishnesses
mawkishnesses2543135_mawkishnesses
modishnesses1844735__modishnesses
mulishnesses1755095__mulishnesses
nighnesses1446465_n___ighnesses
nippinesses1545065_nippi__nesses
noisinesses1139455_n__oisinesses
offishness1943795__offishne_s_s
owlishnesses1844645__owlishnesses
peevishnesses2143465_peevishnesses
pettishnesses1844385_pettishnesses
prankishnesses2353205prankishnesses
prudishnesses1943675_prudishnesses
puckishnesses2443335_puckishnesses
puffinesses1934505_puffi__nesses
qualmishnesses2852075qualmishnesses
raffishness2043375_raffishne_s_s
rakishnesses1944985__rakishnesses
reddishnesses1873585_reddishnesses
roguishnesses1763965_roguishnesses
ruttishnesses1644035_ruttishnesses
scruffinesses2151565scruffi__nesses
selfishness1743815s_elfishne_s_s
selflessnesses15115985selflessnesses
shiftlessnesses1954985shiftlessnesses
shininesses1448295shi_ni__nesses
sickishness2043655s_ickishne_s_s
silkinesses1557905s_ilki__nesses
sillinesses1169845s_illi__nesses
sinfulnesses1546125s_inf_ulnesses
sinlessnesses1157965s_inlessnesses
sinuousnesses1247295sinuous_nesses
sissinesses9118305s_i__ssinesses
sissynesses12123425s_i__ssynesses
sizinesses1938645s_i_zi__nesses
skillessnesses1655605skillessnesses
skimpinesses2043185skimpi__nesses
skinninesses1643475skinni__nesses
skittishness1952415skittishne_s_s
sliminesses1338095sli_mi__nesses
slinkinesses1645815slinki__nesses
snakinesses1538555sn_aki__nesses
snappinesses1684325snappi__nesses
snappishness1952285snappishne_s_s
sneakinesses1645905sneaki__nesses
snidenesses1248655sn___idenesses
snobbishness1952095snobbishne_s_s
snootinesses1265795snooti__nesses
snottinesses1255835snotti__nesses
snowinesses1436415sn_owi__nesses
snubbinesses1643395snubbi__nesses
spicinesses1547095spi_ci__nesses
spiffiness1842985spiffi__ne_s_s
spikinesses1746525spi_ki__nesses
spininesses1358455spi_ni__nesses
squeamishnesses2871215squeamishnesses
squishinesses2442905s__quishinesses
stickinesses1845075sticki__nesses
stinginesses1375965stingi__nesses
swiftnesses1744505swi_f__tnesses
swinishness1743575swi_nishne_s_s
ticklishnesses2352385ticklishnesses
tigerishnesses1852785tigerishnesses
unfairnesses1543435un_fai_rnesses
unfitnesses1446125un__fi_tnesses
uniformnesses1852075uni_formnesses
uppishnesses1943605__uppishnesses
vaporishnesses2252235vaporishnesses
voguishnesses2063485_voguishnesses
waggishnesses2143285_waggishnesses
waspishnesses2043285_waspishnesses
waterishnesses2053165waterishnesses
womanishnesses2252815womanishnesses

Search took 9 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 Filter178691950240.1231452772.4
2DLD Change Limit950241668.11011716.9
3Display Results1661660.1101509.1
 (SQL Overall)1786911668.34321418.1
 
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.