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

175 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
foaminesses165806(None) 
loaminesses1358441loaminesses
filminesses1636232filminesses
flakinesses1837072flakinesses
foaminess1437502foamine_s_s
fogginesses1645492fogginesses
forkinesses1847992forkinesses
foxinesses20127732fo_xinesses
fozinesses22158192fo_zinesses
gaminesses13410462_gaminesses
hoarinesses14310212hoarinesses
hominesses15510852ho_minesses
roominesses1337422roominesses
seaminesses13310752seaminesses
soapinesses1339702soapinesses
worminesses16127982worminesses
balminesses1537253balminesses
beadinesses1449563beadinesses
bogginesses1555673bogginesses
boninesses121111453bo_ninesses
bonninesses1337353bonninesses
boozinesses22175803boozinesses
boskinesses17136813boskinesses
bossinesses12117353bossinesses
boxinesses19127903bo_xinesses
caginesses13310943_caginesses
cakinesses16310613_cakinesses
campinesses1737113_campinesses
charinesses1639563charinesses
clamminesses1873793clamminesses
cockinesses1947553cockinesses
comfinesses1846903comfinesses
corkinesses1749203corkinesses
corninesses13410583corninesses
cosinesses121012823co_sinesses
cozinesses21179503co_zinesses
crazinesses2237923crazinesses
creaminesses1646123creaminesses
dampnesses1535603_dampnesses
dodginesses1435433dodginesses
dopinesses13159723do_pinesses
dorkinesses1647653dorkinesses
dottinesses1238123dottinesses
dowdinesses1635723dowdinesses
downinesses1536143downinesses
dozinesses20168633do_zinesses
dreaminesses1545703dreaminesses
easinesses10314433_easinesses
fairnesses1357383f_airnesses
fancinesses1638143fancinesses
farnesses122310813f_a_rnesses
fastnesses1389083f_astnesses
fatnesses121710463f_a_tnesses
fattinesses14118973fattinesses
fierinesses1439233fierinesses
finesses111912343f___inesses
firmnesses1535613firm_nesses
fishinesses17107243fishinesses
flabbinesses1943073flabbinesses
flashinesses18124863flashinesses
flatnesses1337763fla_tnesses
flimsinesses1743993flimsinesses
floppinesses1942953floppinesses
flukinesses1836093flukinesses
folksinesses1964063folksinesses
fondnesses1437703fo_ndnesses
formalnesses1744463formalnesses
foulnesses1337923fo_ulnesses
frailnesses1447573frailnesses
franknesses1845603franknesses
freakinesses1945583freakinesses
frostinesses1546523frostinesses
frothinesses1845593frothinesses
funkinesses18137003funkinesses
funninesses14106873funninesses
furrinesses1437183furrinesses
fussinesses13126943fussinesses
fustinesses14129783fustinesses
fuzzinesses2243723fuzzinesses
gamenesses1368983_gamenesses
gemminesses1634973gemminesses
germinesses1437873germinesses
glarinesses1239513glarinesses
glazinesses2136403glazinesses
gloominesses1544123gloominesses
godlinesses1337123godlinesses
goofinesses1535963goofinesses
gorinesses11311543go_rinesses
goutinesses1239963goutinesses
grapinesses1438563grapinesses
griminesses14167553griminesses
gumminesses1634933gumminesses
hamminesses1835773hamminesses
hazinesses2239223_hazinesses
headinesses1539843headinesses
heavinesses1747453heavinesses
hokinesses1758943ho_kinesses
holinesses13511493ho_linesses
horninesses1458993horninesses
horsinesses1439543horsinesses
jokinesses2147533jo_kinesses
jollinesses1836723jollinesses
jowlinesses2135323jowlinesses
kookinesses1435373kookinesses
lacinesses12312113_lacinesses
lamenesses12610563_lamenesses
lazinesses19310153_lazinesses
leafinesses1437873leafinesses
leakinesses1538473leakinesses
liminesses121310853_liminesses
loaminess1137493loamine_s_s
loathnesses1445853loathnesses
loftinesses1437913loftinesses
loginesses11410323lo_ginesses
looninesses1197993looninesses
loopinesses13116733loopinesses
lousinesses111210323lousinesses
lowlinesses1436683lowlinesses
matinesses12314533_matinesses
mazinesses2139913_mazinesses
mealinesses13310973mealinesses
meatinesses13311973meatinesses
moldinesses14138043moldinesses
moodinesses14147643moodinesses
mooninesses13127943mooninesses
mopinesses14139123mo_pinesses
mossinesses12117463mossinesses
mousinesses13129833mousinesses
noisinesses1139473noisinesses
nosinesses101411313no_sinesses
oilinesses101512443_oilinesses
oozinesses19178023_oozinesses
pokinesses1669613po_kinesses
porkinesses1748763porkinesses
pottinesses1339093pottinesses
quakinesses2436303quakinesses
racinesses12313503_racinesses
readinesses12611263readinesses
riminesses121211413_riminesses
rockinesses1737353rockinesses
rootinesses1139513rootinesses
ropinesses121311023ro_pinesses
rosinesses101213143ro_sinesses
rowdinesses1536963rowdinesses
samenesses12410853_samenesses
scalinesses1339313scalinesses
scarinesses1339903scarinesses
shadinesses1538643shadinesses
shakinesses1837613shakinesses
slatinesses11311613slatinesses
sliminesses1338093sliminesses
smarminesses1645103smarminesses
snakinesses1538553snakinesses
sogginesses1346773sogginesses
sootinesses11410043sootinesses
soppinesses1566843soppinesses
sorrinesses11310083sorrinesses
spacinesses1538093spacinesses
staginesses1238463staginesses
steaminesses1446223steaminesses
storminesses1445023storminesses
swampinesses1943713swampinesses
tamenesses1259963_tamenesses
tearinesses11311693tearinesses
warinesses131514523_warinesses
wavinesses16199283_wavinesses
waxinesses20138763_waxinesses
wearinesses14310213wearinesses
womannesses1644373womannesses
woodinesses15127463woodinesses
woolinesses14157503woolinesses
woozinesses23175633woozinesses
wordinesses15138873wordinesses
yumminesses1843873yumminesses
zaninesses19310383_zaninesses

Search took 6 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 Filter1786911216330.1401276364.3
2DLD Change Limit1216331754.90624792.7
3Display Results1751750.0931881.7
 (SQL Overall)1786911755.13934771.6
 
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.