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

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

263 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
earwitnesses154378(None) 
earlinesses11311042earli_nesses
earwitness1342622earwitne_s_s
eyewitnesses1852112eyewitnesses
adroitnesses1344133adroitnesses
arbitresses1343343_arbitresses
aridnesses1139933_ar_idnesses
artinesses10815213_arti_nesses
earnestnesses1353663earnestnesses
earthinesses1545823earthinesses
easinesses10314443ea_si_nesses
eerinesses10612603eer_i_nesses
erectnesses1347473e_rectnesses
hardinesses151110213hardi_nesses
heartinesses1548003hearti_nesses
larkinesses1538993larki_nesses
peartnesses1338743pear__tnesses
straitnesses1246213straitnesses
tacitnesses1336323ta_citnesses
tardinesses121110243tardi_nesses
tarrinesses11129083tarri_nesses
tartinesses111011503tarti_nesses
tartnesses101110713tar__tnesses
tearinesses11311693tear_i_nesses
warinesses131514523war_i_nesses
wearinesses14310213wear_i_nesses
witnesses12219923___witnesses
abruptnesses1652614abruptnesses
achinesses1539304_achi_nesses
acidnesses1337254_a_cidnesses
acridnesses1445784_acridnesses
adeptnesses1444834_adeptnesses
adultnesses1244834_adultnesses
airinesses102613614_airi_nesses
alertnesses1147234_alertnesses
algidnesses1345164_algidnesses
apartnesses1346824_apartnesses
aptnesses11168994_a__ptnesses
archnesses1547174_ar_chnesses
artsinesses1138714_artsinesses
ashinesses1339164_ashi_nesses
avidnesses1436464_a_vidnesses
awaynesses1644274_a_waynesses
bagginesses1545954baggi_nesses
balkinesses1767504balki_nesses
balminesses1537254balmi_nesses
bandinesses14109734bandi_nesses
barenesses12311704bar__enesses
baronesses1238914bar__onesses
barrennesses1443434barrennesses
battinesses13169454batti_nesses
bawdinesses17126324ba_wdinesses
beadinesses1449564bea_di_nesses
beardednesses1744144beardednesses
bearishnesses1844844bearishnesses
beerinesses1398924beer_i_nesses
blearinesses1446544blear_i_nesses
blowinesses1635984blowi_nesses
brattinesses1466264brattinesses
brawninesses1744704brawninesses
burlinesses1338404burli_nesses
caginesses13310944ca_gi_nesses
cakinesses16310614ca_ki_nesses
campinesses1737114campi_nesses
candidnesses1685394candidnesses
canninesses1368854canni_nesses
cattinesses13129704catti_nesses
charinesses1639564char_i_nesses
chewinesses1945144chewi_nesses
corkinesses1749214corki_nesses
corninesses13410594corni_nesses
craftinesses1746384craftinesses
crazinesses2237934crazi_nesses
curlinesses1338734curli_nesses
curtnesses1238374cur__tnesses
daffinesses1834844daffi_nesses
daftnesses1436384da__ftnesses
dailinesses1249494daili_nesses
daintinesses1346244daintinesses
daringnesses1464834daringnesses
darknesses1537014dar__knesses
darlingnesses1563044darlingnesses
deadlinesses1446224deadli_nesses
dearnesses1139584dear___nesses
dewinesses1438354_dewi_nesses
directnesses1595284directnesses
dirtinesses1239884dirti_nesses
dorkinesses1647664dorki_nesses
draftinesses1645754draftinesses
drearinesses1347444drear_i_nesses
eagernesses1246984ea_gernesses
earliness939694earli_ne_s_s
earthlinesses1643914earthlinesses
edginesses1236704e_dgi_nesses
editresses1165074e__ditresses
emptinesses1545994empti_nesses
evilnesses1346004e__vilnesses
exactnesses2044344e_xactnesses
exoticnesses2142684exoticnesses
expertnesses2144844expertnesses
eyewitness1641474eyewitne_s_s
faintnesses1447144fa_intnesses
fairnesses1357384fa__irnesses
fancinesses1638144fanci_nesses
farnesses122310814far___nesses
fastnesses1389084fa__stnesses
fatnesses121710464fa___tnesses
fattinesses14118974fatti_nesses
faultinesses1545184faultinesses
fearfulnesses1945314fearfulnesses
fervidnesses1943844fervidnesses
firstnesses1445734fir_stnesses
fitnesses12219374___fitnesses
forkinesses1848004forki_nesses
frailnesses1447594_frailnesses
fruitinesses1546444_fruitinesses
furrinesses1437184furri_nesses
gabbinesses1634904gabbi_nesses
gaminesses13410464ga_mi_nesses
garishnesses1645884garishnesses
gassinesses1197974gassi_nesses
gastnesses11129144ga__stnesses
gaudinesses1337854gaudi_nesses
gauntnesses1245174ga_untnesses
gauzinesses2136044gauzi_nesses
gawkinesses1935634ga_wkinesses
germinesses1437884germi_nesses
glarinesses1239514glar_i_nesses
gorinesses11311554gor_i_nesses
grapinesses1438574grapi_nesses
greatnesses1247794_greatnesses
grimnesses13106534_gr_imnesses
hairinesses14198944hairi_nesses
hamminesses1835774hammi_nesses
handinesses151410274handi_nesses
happinesses1876164happi_nesses
hardnesses141810544har__dnesses
harnesses121812074har___nesses
harshnesses1745854har_shnesses
hastinesses141210694hasti_nesses
hazinesses2239224ha_zi_nesses
headinesses1539844hea_di_nesses
heavinesses1747454hea_vi_nesses
hoarinesses14310224hoar_i_nesses
horninesses1459004horni_nesses
horridnesses1644464horridnesses
horsinesses1439554horsi_nesses
jauntinesses1944684jauntinesses
jazzinesses2633374jazzi_nesses
jerkinesses2246054jerki_nesses
lacinesses12312124la_ci_nesses
lankinesses1539014lanki_nesses
largenesses1247554lar_genesses
lazinesses19310154la_zi_nesses
leafinesses1437874lea_fi_nesses
leakinesses1538474lea_ki_nesses
learnednesses1443644learnednesses
leerinesses11119484leer_i_nesses
licitnesses1346414_licitnesses
luridnesses1246724lur_idnesses
maltinesses13310234malti_nesses
manginesses1499594mangi_nesses
manlinesses13910194manli_nesses
marchionesses2052364marchionesses
markednesses1944184markednesses
marshinesses1744964marshinesses
massinesses12128694massi_nesses
matinesses12314544ma_ti_nesses
mazinesses2139924ma_zi_nesses
mealinesses13310974mea_li_nesses
meatinesses13311984mea_ti_nesses
merrinesses1358264merri_nesses
mirinesses121512314mir_i_nesses
morbidnesses1743974morbidnesses
murkinesses17136784murki_nesses
nappinesses1555924nappi_nesses
narrownesses1562744narrownesses
nastinesses111110744nasti_nesses
nattinesses11119324natti_nesses
nearnesses1039104near___nesses
neatnesses10310014nea___tnesses
nerdinesses1249054nerdi_nesses
nervinesses1437324nervi_nesses
pallidnesses1543924pallidnesses
pastinesses13911714pasti_nesses
pastnesses12910514pa__stnesses
patnesses111611794pa___tnesses
pawkinesses2036154pa_wkinesses
perkinesses1748924perki_nesses
pertnesses12310314per__tnesses
porkinesses1748774porki_nesses
primnesses1497804_pr_imnesses
pursinesses1338744pursi_nesses
rabidnesses1476134ra_bidnesses
racinesses12313514ra_ci_nesses
raininesses11310484raini_nesses
rancidnesses1544884rancidnesses
randinesses121311204randi_nesses
ranginesses121210114rangi_nesses
rapidnesses1476474ra_pidnesses
raptnesses1248524__raptnesses
rarenesses10313114rar__enesses
raspinesses1338014raspi_nesses
rawnesses1288124ra_w__nesses
readinesses12611274rea_di_nesses
saltinesses11311454salti_nesses
saltnesses10310164sa__ltnesses
sandinesses12911394sandi_nesses
sappinesses1567564sappi_nesses
sassinesses999324sassi_nesses
saucinesses1338984sauci_nesses
savvinesses1735664savvi_nesses
scarinesses1339904scar_i_nesses
screwinesses1744744screwi_nesses
seaminesses13310754sea_mi_nesses
showinesses1735994showi_nesses
smarminesses1645104smarmi_nesses
smartnesses1337144smar__tnesses
snowinesses1436414snowi_nesses
sordidnesses1445174sordidnesses
sorrinesses11310094sorri_nesses
strictnesses1445414strictnesses
surlinesses11310054surli_nesses
swartnesses1436714swar__tnesses
swiftnesses1744504__swiftnesses
tackinesses1737254tacki_nesses
talkinesses1537354talki_nesses
tanginesses1278884tangi_nesses
tastinesses111110784tasti_nesses
tattinesses11128944tatti_nesses
tautnesses10118284ta__utnesses
tawninesses1436154ta_wninesses
tearfulnesses1645534tearfulnesses
torridnesses1344654torridnesses
traitresses1144604_traitresses
trignesses1188214_tr_ignesses
trimnesses1287754_tr_imnesses
tritenesses11710394_tr_itenesses
turbidnesses1543554turbidnesses
turgidnesses1453624turgidnesses
unfitnesses1446134_unfitnesses
vacantnesses1742974vacantnesses
vainnesses1337344va__innesses
validnesses1576024va_lidnesses
vapidnesses1774894va_pidnesses
vastnesses13128204va__stnesses
wackinesses2036654wacki_nesses
waitresses1345064wa__itresses
warmnesses15167354war__mnesses
washinesses1737264washi_nesses
waspinesses1636704waspi_nesses
wavinesses16199284wa_vi_nesses
waxinesses20138764wa_xi_nesses
weaklinesses1944484weakli_nesses
wetnesses12208214___wetnesses
wirinesses131811524wir_i_nesses
witnessed13214724___witnessed
witnesser12224534___witnesser
witnessers13173104___witnessers
wordinesses15138884wordi_nesses
worminesses16127994wormi_nesses
yeastinesses1545564yeasti_nesses
zaninesses19310384za_ni_nesses

Search took 8 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 Filter1786911247900.393454684.5
2DLD Change Limit1247902637.37316925.3
3Display Results2632630.1561685.9
 (SQL Overall)1786912637.92222556.3
 
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.