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

104 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
unfairnesses154343(None) 
fairnesses1357382__fairnesses
unfairness1342812unfairne_s_s
unfitnesses1446132unf_itnesses
unharnesses1445432unha_rnesses
unwarinesses1546152unwarinesses
farnesses122310813__fa_rnesses
nearnesses1039103_nea_rnesses
unaptnesses1395523un_aptnesses
uneasinesses1246623uneasinesses
unharnessed1553403unha_rnessed
airinesses102613614___airinesses
angrinesses1247284angri_nesses
antsinesses1148754antsi_nesses
blearinesses1446544blearinesses
charinesses1639564_charinesses
clearnesses13106154clea_rnesses
daffinesses1834844daffi_nesses
dearnesses1139584_dea_rnesses
drearinesses1347444drearinesses
entirenesses1249664en_tirenesses
faintnesses1447144__faintnesses
fairness1136564__fairne_s_s
fastnesses1389084__fastnesses
fatnesses121710464__fa_tnesses
finesses111912344__f_i_nesses
firmnesses1535614__f_irmnesses
fitnesses12219374__f_itnesses
frailnesses1447594_frailnesses
funkinesses18137004fun_ki_nesses
funninesses14106874fun_ni_nesses
glarinesses1239514_glarinesses
hairinesses14198944__hairinesses
harnesses121812074__ha_rnesses
heftinesses1737134hefti_nesses
hoarinesses14310224_hoarinesses
huffinesses2034124huffi_nesses
hungrinesses1643854hungri_nesses
iffinesses1635584_iffi_nesses
inanenesses1149524in_anenesses
inaptnesses1385634in_aptnesses
inkinesses1439424in_ki_nesses
innatenesses1247184innatenesses
innernesses1146734in_nernesses
insanenesses1246874insanenesses
intactnesses1444574intactnesses
invernesses1447034in_vernesses
inwardnesses1654674inwardnesses
leafinesses1437874leafi_nesses
loftinesses1437924lofti_nesses
miffinesses1944364miffi_nesses
mundanenesses1653544mundanenesses
naivenesses1449114_n_aivenesses
neatnesses10310014_nea_tnesses
niftinesses1437244nifti_nesses
nosinesses101411324_nosi_nesses
nubbinesses1544294nubbi_nesses
nuttinesses11117754nutti_nesses
plainnesses1356204_plainnesses
puffinesses1934514puffi_nesses
puninesses121110754pun__i_nesses
punkinesses17127224pun_ki_nesses
runninesses11137694run_ni_nesses
runtinesses111210964run_ti_nesses
scarinesses1339904_scarinesses
snakinesses1538554sn_akinesses
sneakinesses1645904sneakinesses
sniffinesses1843694sniffi_nesses
snowinesses1436414snowi_nesses
staidnesses1237194_staidnesses
straitnesses1246214straitnesses
sunninesses11148384sun_ni_nesses
tearinesses11311694_tearinesses
uglinesses1138544u_gli_nesses
unawarenesses1653734unawarenesses
uncanninesses1553134uncanninesses
undresses1039314un__dr_esses
unevennesses1544074unevennesses
unfairest1243564unfair_e_s_t
unfitness1244844unf_itne_s_s
ungainlinesses1562834ungainlinesses
unhandinesses1753714unhandinesses
unhappinesses2052484unhappinesses
unharness1245254unha_rne_s_s
unholinesses1544914unholinesses
uniformnesses1852084uniformnesses
uniquenesses2154714uniquenesses
unjustnesses1963114unjustnesses
unkindnesses1744384unkindnesses
unlikenesses1645814unlikenesses
unmanlinesses1574314unmanlinesses
unquietnesses2253054unquietnesses
unreadinesses1484584unreadinesses
unripenesses1446014unripenesses
unrulinesses1245804unrulinesses
unstresses1046034un_str_esses
untidinesses1345914untidinesses
unwariness1365884unwarine_s_s
upwardnesses1843094upwardnesses
usualnesses1144694usua_lnesses
utternesses1145874u_tternesses
vainnesses1337344__vainnesses
warinesses131514524__warinesses
wearinesses14310214_wearinesses

Search took 9 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.423422437.4
2DLD Change Limit1247901047.90615784.2
3Display Results1041040.0601733.3
 (SQL Overall)1786911048.38921300.6
 
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.