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

191 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
earlinesses1131105(None) 
artinesses10815232_artinesses
burlinesses1338402burlinesses
curlinesses1338732curlinesses
dailinesses1249492dailinesses
deadlinesses1446222deadlinesses
earliness939712earline_s_s
earthinesses1545822earthinesses
earthlinesses1643912earthlinesses
earwitnesses1543782earwitnesses
easinesses10314442ea_sinesses
eerinesses10612602eer_inesses
hardinesses151110232hardinesses
heartinesses1548002heartinesses
larkinesses1539002larkinesses
manlinesses13910192manlinesses
mealinesses13310972mea_linesses
surlinesses11310052surlinesses
tardinesses121110262tardinesses
tarrinesses11129092tarrinesses
tartinesses111011512tartinesses
tearinesses11311692tear_inesses
warinesses131514532war_inesses
weaklinesses1944482weaklinesses
wearinesses14310212wear_inesses
achinesses1539303_achinesses
airinesses102613633_airinesses
archnesses1547173_archnesses
aridnesses1139943_aridnesses
artsinesses1138733_artsinesses
ashinesses1339163_ashinesses
bagginesses1545953bagginesses
baldnesses1337653ba_ldnesses
balkinesses1767503balkinesses
balminesses1537253balminesses
bandinesses14109733bandinesses
barenesses12311703bar_enesses
baronesses1238913bar_onesses
battinesses13169453battinesses
bawdinesses17126323bawdinesses
beadinesses1449563bea_dinesses
beastlinesses1563423beastlinesses
beerinesses1398923beer_inesses
beggarlinesses1871883beggarlinesses
blearinesses1446543blear_inesses
caginesses13310943ca_ginesses
cakinesses16310613ca_kinesses
calmnesses1436843ca_lmnesses
campinesses1737113campinesses
canninesses1368853canninesses
cattinesses13129703cattinesses
charinesses1639563char_inesses
cleanlinesses1553883cleanlinesses
corkinesses1749223corkinesses
corninesses13410603corninesses
crazinesses2237933crazinesses
daffinesses1834843daffinesses
dailynesses1543943dailynesses
darknesses1537013dar_knesses
darlingnesses1563053darlingnesses
dearnesses1139583dear__nesses
dirtinesses1239883dirtinesses
dorkinesses1647663dorkinesses
drearinesses1347443drear_inesses
eagernesses1246983eagernesses
edginesses1236703e_dginesses
elderlinesses1453263elderlinesses
emptinesses1545993emptinesses
evilnesses1346003evil_nesses
fancinesses1638143fancinesses
farnesses122310813far__nesses
fattinesses14118973fattinesses
faultinesses1545183faultinesses
forkinesses1848003forkinesses
frailnesses1447603frailnesses
furrinesses1437193furrinesses
gabbinesses1634913gabbinesses
gaminesses13410463ga_minesses
gassinesses1197983gassinesses
gaudinesses1337863gaudinesses
gauzinesses2136053gauzinesses
gawkinesses1935633gawkinesses
germinesses1437883germinesses
glarinesses1239513glar_inesses
godlinesses1337123godlinesses
gorinesses11311553gor_inesses
grapinesses1438583grapinesses
hairinesses14198943hairinesses
halenesses13312043ha_lenesses
halfnesses1636263ha_lfnesses
hamminesses1835773hamminesses
handinesses151410273handinesses
happinesses1876163happinesses
hardnesses141810543har_dnesses
harnesses121812073har__nesses
harshnesses1745853harshnesses
hastinesses141210693hastinesses
hazinesses2239223ha_zinesses
headinesses1539843hea_dinesses
heavinesses1747453hea_vinesses
hillinesses1458503hillinesses
hoarinesses14310223hoar_inesses
holinesses13511493_holinesses
horninesses1459003horninesses
horsinesses1439563horsinesses
jazzinesses2633373jazzinesses
jerkinesses2246053jerkinesses
jollinesses1836723jollinesses
jowlinesses2135323jowlinesses
lacinesses12312123la_cinesses
lankinesses1539013lankinesses
largenesses1247553largenesses
lazinesses19310153la_zinesses
leafinesses1437873lea_finesses
leakinesses1538473lea_kinesses
leerinesses11119483leer_inesses
lordlinesses1345173lordlinesses
lowlinesses1436683lowlinesses
malenesses12312223ma_lenesses
maltinesses13310233maltinesses
manginesses1499593manginesses
marshinesses1744963marshinesses
massinesses12128693massinesses
matinesses12314543ma_tinesses
mazinesses2139923ma_zinesses
meatinesses13311983mea_tinesses
merrinesses1358263merrinesses
mirinesses121512323mir_inesses
murkinesses17136783murkinesses
nappinesses1555923nappinesses
nastinesses111110743nastinesses
nattinesses11119323nattinesses
nearnesses1039113near__nesses
nerdinesses1249053nerdinesses
nervinesses1437323nervinesses
oilinesses101512443_oilinesses
palenesses12312663pa_lenesses
pallidnesses1543923pallidnesses
pastinesses13911723pastinesses
pawkinesses2036163pawkinesses
peartnesses1338743pear_tnesses
perkinesses1748933perkinesses
porkinesses1748783porkinesses
portlinesses1446993portlinesses
pursinesses1338763pursinesses
racinesses12313513ra_cinesses
raininesses11310503raininesses
randinesses121311203randinesses
ranginesses121210113ranginesses
rarenesses10313113rar_enesses
raspinesses1338013raspinesses
readinesses12611273rea_dinesses
realnesses10310853rea_l_nesses
saltinesses11311453saltinesses
saltnesses10310163sa_ltnesses
sandinesses12911393sandinesses
sappinesses1567563sappinesses
sassinesses999323sassinesses
saucinesses1338983saucinesses
savvinesses1735663savvinesses
scalinesses1339323scalinesses
scarinesses1339903scar_inesses
seaminesses13310753sea_minesses
seemlinesses1445223seemlinesses
sillinesses1169843sillinesses
smarminesses1645103smarminesses
sorrinesses11310093sorrinesses
tackinesses1737253tackinesses
talkinesses1537353talkinesses
tallnesses1037473ta_llnesses
tanginesses1278883tanginesses
tartnesses101110713tar_tnesses
tastinesses111110783tastinesses
tattinesses11128943tattinesses
tawninesses1436153tawninesses
uglinesses1138543_uglinesses
unrulinesses1245813unrulinesses
validnesses1576023va_lidnesses
wackinesses2036653wackinesses
warmnesses15167353war_mnesses
washinesses1737263washinesses
waspinesses1636703waspinesses
wavinesses16199283wa_vinesses
waxinesses20138763wa_xinesses
wilinesses131911093_wilinesses
wirinesses131811533wir_inesses
woolinesses14157503woolinesses
wordinesses15138883wordinesses
worminesses16127993worminesses
yeastinesses1545563yeastinesses
zaninesses19310383za_ninesses

Search took 10 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.453394461.4
2DLD Change Limit1216331918.90613657.4
3Display Results1911910.1101736.4
 (SQL Overall)1786911919.46918871.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.