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

171 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
glarinesses123951(None) 
glazinesses2136401glazinesses
blearinesses1446542blearinesses
charinesses1639562charinesses
flakinesses1837072flakinesses
gaminesses13410462g_aminesses
gladnesses1236682gla_dnesses
glariness1038552glarine_s_s
glaringnesses1553392glaringnesses
glassinesses1255242glassinesses
gluinesses1138232gl_uinesses
gorinesses11311552g_orinesses
grapinesses1438572grapinesses
hoarinesses14310222hoarinesses
lacinesses12312122_lacinesses
larkinesses1538992_larkinesses
lazinesses19310152_lazinesses
scarinesses1339902scarinesses
slatinesses11311632slatinesses
tearinesses11311692tearinesses
warinesses131514522_warinesses
wearinesses14310212wearinesses
airinesses102613613_airinesses
alertnesses1147233alertnesses
angrinesses1247283angrinesses
apartnesses1346823apartnesses
aridnesses1139933__aridnesses
artinesses10815213__artinesses
awarenesses1447253awarenesses
balkinesses1767503balkinesses
balminesses1537253balminesses
barenesses12311703_barenesses
baronesses1238913_baronesses
beadinesses1449563beadinesses
beerinesses1398923beerinesses
blacknesses1944993blacknesses
blandnesses1446623blandnesses
blanknesses1744933blanknesses
blowinesses1635983blowinesses
blurrinesses1484113blurrinesses
caginesses13310943_caginesses
cakinesses16310613_cakinesses
clamminesses1873793clamminesses
classinesses1366113classinesses
clearnesses13106153clear_nesses
crazinesses2237933crazinesses
darknesses1537013_darknesses
dearnesses1139583dear_nesses
drearinesses1347443drearinesses
dwarfnesses1843293dwarfnesses
earlinesses11311043_earlinesses
easinesses10314443_easinesses
eerinesses10612603_eerinesses
fairnesses1357383_fairnesses
farnesses122310813_far_nesses
fierinesses1439233fierinesses
flabbinesses1943073flabbinesses
flashinesses18124863flashinesses
flatnesses1337763fla_tnesses
floridnesses1654133floridnesses
flukinesses1836093flukinesses
foaminesses1658073foaminesses
furrinesses1437183furrinesses
gabbinesses1634903gabbinesses
gamenesses1368983g_amenesses
garishnesses1645883g_arishnesses
gassinesses1197973gassinesses
gastnesses11129143g_astnesses
gaudinesses1337853gaudinesses
gauzinesses2136043gauzinesses
gawkinesses1935633gawkinesses
gaynesses1336563g_a_ynesses
geekinesses1635813geekinesses
gemminesses1634983gemminesses
germinesses1437883germinesses
giddinesses1435303giddinesses
glaringness1343263glaringness
glaziness1935753glazine_s_s
glegnesses1245073gl_egnesses
glibnesses1344753gl_ibnesses
gloominesses1544123gloominesses
glossinesses1254493glossinesses
glueynesses1543703glueynesses
glumnesses1344733gl_umnesses
godlinesses1337123godlinesses
goofinesses1535963goofinesses
goutinesses1239973goutinesses
graininesses1346593graininesses
grandnesses1348113grandnesses
gravenesses1548173gravenesses
graynesses1436143gra_ynesses
greasinesses1347043greasinesses
griminesses14167553griminesses
grimnesses13106533g__rimnesses
gumminesses1634933gumminesses
gushinesses15127023gushinesses
gustinesses12139523gustinesses
gutsinesses12128153gutsinesses
hairinesses14198943hairinesses
hardinesses151110223_hardinesses
hardnesses141810543_hardnesses
harnesses121812073_har_nesses
hazinesses2239223_hazinesses
headinesses1539843headinesses
heartinesses1548003heartinesses
heavinesses1747453heavinesses
lamenesses12610563_lamenesses
lankinesses1539013_lankinesses
lanknesses1437503_lanknesses
largenesses1247553_largenesses
largesses10246273_lar_gesses
latenesses10413363_latenesses
laxnesses1646633_la_xnesses
leafinesses1437873leafinesses
leakinesses1538473leakinesses
leerinesses11119483leerinesses
liminesses121310853_liminesses
loaminesses1358453loaminesses
loginesses11410323_loginesses
lornnesses1037823_lornnesses
luridnesses1246723_luridnesses
maltinesses13310233maltinesses
matinesses12314543_matinesses
mazinesses2139923_mazinesses
mealinesses13310973mealinesses
meatinesses13311983meatinesses
merrinesses1358263merrinesses
mirinesses121512313_mirinesses
nearnesses1039103near_nesses
paltrinesses1445513paltrinesses
peartnesses1338743peartnesses
placidnesses1743953placidnesses
plainnesses1356203plainnesses
planenesses1349033planenesses
quakinesses2436323quakinesses
racinesses12313513_racinesses
rarenesses10313113_rarenesses
readinesses12611273readinesses
saltinesses11311453saltinesses
scalinesses1339323scalinesses
seaminesses13310753seaminesses
shadinesses1538643shadinesses
shakinesses1837613shakinesses
sharpnesses1645233sharpnesses
slacknesses1745243slacknesses
slanginesses1346963slanginesses
sleazinesses2145373sleazinesses
sliminesses1338093sliminesses
smarminesses1645103smarminesses
smartnesses1337143smartnesses
snakinesses1538553snakinesses
soapinesses1339713soapinesses
sorrinesses11310093sorrinesses
spacinesses1538103spacinesses
sparenesses1339173sparenesses
staginesses1238463staginesses
starknesses1545883starknesses
sultrinesses1245883sultrinesses
swartnesses1436713swartnesses
talkinesses1537353talkinesses
tardinesses121110253_tardinesses
tarrinesses11129083tarrinesses
tartinesses111011503_tartinesses
tartnesses101110713_tartnesses
uglinesses1138543ugl__inesses
unwarinesses1546153unwarinesses
warmnesses15167353_warmnesses
wavinesses16199283_wavinesses
waxinesses20138763_waxinesses
wirinesses131811523_wirinesses
zaninesses19310383_zaninesses

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 Filter1786911216330.393454684.5
2DLD Change Limit1216331715.53021995.1
3Display Results1711710.1101554.5
 (SQL Overall)1786911716.03329618.9
 
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.