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

179 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
hairinesses1419894(None) 
airinesses102613611_airinesses
charinesses1639562cha_rinesses
dailinesses1249492dailinesses
fairnesses1357382fair_nesses
hairiness1238012hairine_s_s
hamminesses1835772hamminesses
handinesses151410272handinesses
happinesses1876162happinesses
hardinesses151110212hardinesses
hardnesses141810542ha_rdnesses
harnesses121812072ha_r_nesses
hastinesses141210692hastinesses
hazinesses2239222ha_zinesses
hoarinesses14310222hoarinesses
mirinesses121512312_mirinesses
raininesses11310482raininesses
tarrinesses11129082tarrinesses
warinesses131514522wa_rinesses
wirinesses131811522_wirinesses
achinesses1539303_achinesses
acridnesses1445783_acridnesses
airiness8412213_airine_s_s
angrinesses1247283angrinesses
aridnesses1139933_aridnesses
artinesses10815213_artinesses
ashinesses1339163_ashinesses
bagginesses1545953bagginesses
balkinesses1767503balkinesses
balminesses1537253balminesses
bandinesses14109733bandinesses
barenesses12311703ba_renesses
baronesses1238913ba_ronesses
battinesses13169453battinesses
bawdinesses17126323bawdinesses
beerinesses1398923beerinesses
braininesses1446553braininesses
brininesses1338983brininesses
caginesses13310943ca_ginesses
cakinesses16310613ca_kinesses
campinesses1737113campinesses
canninesses1368853canninesses
cattinesses13129703cattinesses
chancinesses1945033chancinesses
chattinesses1755153chattinesses
cheerinesses1765823cheerinesses
daffinesses1834843daffinesses
dailynesses1543943dailynesses
daintinesses1346243daintinesses
darknesses1537013da_rknesses
direnesses11311483_direnesses
dirtinesses1239883_dirtinesses
earlinesses11311043earlinesses
easinesses10314443ea_sinesses
eerinesses10612603_eerinesses
faintnesses1447143faintnesses
fancinesses1638143fancinesses
farnesses122310813fa_r_nesses
fattinesses14118973fattinesses
fierinesses1439233fierinesses
firmnesses1535613_firmnesses
furrinesses1437183furrinesses
gabbinesses1634903gabbinesses
gaminesses13410463ga_minesses
gassinesses1197973gassinesses
gaudinesses1337853gaudinesses
gauzinesses2136043gauzinesses
gawkinesses1935633gawkinesses
glarinesses1239513glarinesses
gorinesses11311553_gorinesses
graininesses1346593graininesses
griminesses14167553griminesses
hairdresser1551933hairdresser
hairdressers1651423hairdressers
halenesses13312043ha_lenesses
halfnesses1636263ha_lfnesses
harnessed13186193ha_r_nessed
harshnesses1745853harshnesses
headinesses1539843headinesses
heartinesses1548003heartinesses
heavinesses1747453heavinesses
heftinesses1737133heftinesses
heiresses1236963heir__esses
highnesses1746083h_ighnesses
hillinesses1458503hillinesses
hipnesses1436753h_i_pnesses
hippinesses1845493hippinesses
hokinesses1758943h_okinesses
holinesses13511493h_olinesses
hominesses15510863h_ominesses
horninesses1459003horninesses
horridnesses1644463horridnesses
horsinesses1439553horsinesses
huffinesses2034123huffinesses
humpinesses18106243humpinesses
hungrinesses1643853hungrinesses
huskinesses18136533huskinesses
icinesses11310073__icinesses
jazzinesses2633373jazzinesses
juicinesses2035893juicinesses
lacinesses12312123la_cinesses
lankinesses1539013lankinesses
larkinesses1538993larkinesses
lazinesses19310153la_zinesses
leerinesses11119483leerinesses
liminesses121310853_liminesses
maltinesses13310233maltinesses
manginesses1499593manginesses
manlinesses13910193manlinesses
massinesses12128693massinesses
matinesses12314543ma_tinesses
mazinesses2139923ma_zinesses
merrinesses1358263merrinesses
naivenesses1449113naivenesses
nappinesses1555923nappinesses
nastinesses111110743nastinesses
nattinesses11119323nattinesses
noisinesses1139483noisinesses
oilinesses101512443_oilinesses
paltrinesses1445513paltrinesses
paperinesses1646053paperinesses
pastinesses13911713pastinesses
patronesses1346473patronesses
pawkinesses2036153pawkinesses
pipinesses1448603_pipinesses
pixinesses1937373_pixinesses
quirkinesses2542893quirkinesses
racinesses12313513ra_cinesses
randinesses121311203randinesses
ranginesses121210113ranginesses
rarenesses10313113ra_renesses
raspinesses1338013raspinesses
riminesses121211413_riminesses
saltinesses11311453saltinesses
sandinesses12911393sandinesses
sappinesses1567563sappinesses
sassinesses999323sassinesses
saucinesses1338983saucinesses
savorinesses1544613savorinesses
savvinesses1735663savvinesses
scarinesses1339903scarinesses
shabbinesses1953433shabbinesses
shadinesses1538643sha_dinesses
shagginesses1743963shagginesses
shakinesses1837613sha_kinesses
sharpnesses1645233sha_rpnesses
shininesses1448293shininesses
sizinesses1938653_sizinesses
sliminesses1338093sliminesses
sorrinesses11310093sorrinesses
spicinesses1547103spicinesses
spikinesses1746523spikinesses
spininesses1358453spininesses
tackinesses1737253tackinesses
talkinesses1537353talkinesses
tanginesses1278883tanginesses
tardinesses121110243tardinesses
tartinesses111011503tartinesses
tartnesses101110713ta_rtnesses
tastinesses111110783tastinesses
tattinesses11128943tattinesses
tawdrinesses1643433tawdrinesses
tawninesses1436153tawninesses
tearinesses11311693tearinesses
tidinesses1139223_tidinesses
tininesses10311163_tininesses
vainnesses1337343vai_nnesses
wackinesses2036653wackinesses
warmnesses15167353wa_rmnesses
washinesses1737263washinesses
waspinesses1636703waspinesses
waterinesses1567193waterinesses
wavinesses16199283wa_vinesses
waxinesses20138763wa_xinesses
wearinesses14310213wearinesses
weirdnesses1545213weirdnesses
whininesses1746183whininesses
wilinesses131911093_wilinesses
zaninesses19310383za_ninesses

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 Limit1216331795.43622375.5
3Display Results1791790.1101627.3
 (SQL Overall)1786911795.68631426.5
 
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.