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

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

175 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
materialnesses165391(None) 
materialness1454662materialne_s_s
eternalnesses1353693_eternalnesses
literalnesses1355243liter_alnesses
masterfulnesses2053293masterfulnesses
materialises1447323material__ises
naturalnesses1354253natur_alnesses
waterinesses1567193wateri__nesses
waterishnesses2053163waterishnesses
etherealnesses1762314etherealnesses
fatalnesses1456284fat___alnesses
fatefulnesses1945994fate_fulnesses
hatefulnesses1945804hate_fulnesses
liberalnesses1554264liber_alnesses
masterlinesses1673524master_linesses
materialise1347834material__ise_
materialised1555474material__ised
materialisms1657304material__isms
materialists1456984material__ists
materialities1566394material_ities
materializes2347224material__izes
mateynesses1645174mate___ynesses
matinesses12314544mat__i__nesses
mercurialnesses1981434mercurialnesses
palatialnesses1653384palatialnesses
paperinesses1646054paperi__nesses
pastoralnesses1653134pastor_alnesses
pictorialnesses1962144pictorialnesses
rationalnesses1452634rationalnesses
specialnesses1753864_specialnesses
venialnesses1555704__venialnesses
acridnesses1445785_a_cri_dnesses
airinesses102613615_a_iri__nesses
alertnesses1147235_aler__tnesses
amativenesses1856785amat__ivenesses
angrinesses1247285_angri__nesses
aridnesses1139935_a__ri_dnesses
averagenesses1755015_averagenesses
aversenesses1545665_aver_senesses
aversivenesses2056565_aversivenesses
balefulnesses1844855bale_fulnesses
battinesses13169455bat_ti__nesses
beerinesses1398925_beeri__nesses
carefulnesses1845695care_fulnesses
casualnesses1443785ca__sualnesses
cateresses1248355cater____esses
cattinesses13129705cat_ti__nesses
cheerfulnesses2253385cheerfulnesses
cheerinesses1765825cheeri__nesses
colonialnesses1653055colonialnesses
cordialnesses1654575_cordialnesses
daringnesses1464835da__ringnesses
datednesses1357905date___dnesses
eagernesses1246985eager___nesses
eerinesses10612605__eeri__nesses
essentialnesses1462645essentialnesses
eternalness1153825_eternalne_s_s
ethicalnesses1853205_ethicalnesses
evilnesses1346005___evi_lnesses
factualnesses1853695fa_ctualnesses
familiarnesses1971785familiarnesses
fanaticalnesses2082315fanaticalnesses
fatherlinesses2052615father_linesses
fattinesses14118975fat_ti__nesses
feverishnesses2382885feverishnesses
fierinesses1439235_fieri__nesses
formalnesses1744485__formalnesses
frailnesses1447595___frailnesses
garishnesses1645885ga__rishnesses
genericnesses1652745generi_cnesses
gratefulnesses18135415grate_fulnesses
habitualnesses1962215habitualnesses
hairinesses14198945ha_iri__nesses
initialnesses1395615_initialnesses
jitterinesses2083315jitteri__nesses
latenesses10413365late____nesses
leerinesses11119485_leeri__nesses
literalness1145495liter_alne_s_s
literarinesses1483355literarinesses
literatenesses1464785literatenesses
liverishnesses2063025liverishnesses
lyricalnesses1853105__lyricalnesses
malenesses12312225male____nesses
maltinesses13310235ma_lti__nesses
manfulnesses1745835ma__nfulnesses
manginesses1499595ma_ngi__nesses
manlinesses13910195ma_nli__nesses
mannerlinesses1652405manner_linesses
mannishnesses1873965ma_nnishnesses
marchionesses2052365marchi_onesses
markednesses1944185ma__rkednesses
marshinesses1744965ma__rshinesses
massinesses12128695ma_ssi__nesses
massivenesses1755915ma_ssivenesses
masterfulness1853515masterfulne_s_s
matelasses1254005mate___l_asses
materialising16114495material_ising
materialism1548265material__is_m
materialist1349515material__is_t
materialistic1774015material_istic
materialize2247885material__ize_
materialized2446555material__ized
materializer2355365material__izer
materializers2453175material_izers
materials11510795material_____s
matrasses1157295mat_r_a___sses
mattrasses1243835mattr_a___sses
mattresses1245435mattr____esses
mawkishnesses2543135ma_wkishnesses
mazednesses2345405maze___dnesses
mazinesses2139925ma__zi__nesses
meagernesses1544445meager___nesses
mealinesses13310975m__e__alinesses
meannesses12128165m__e__annesses
meatinesses13311985meat__i__nesses
mercifulnesses2154275m__ercifulnesses
merrinesses1358265m__er_rinesses
mirinesses121512315m__iri__nesses
miserablenesses1954665miserablenesses
miserlinesses1554665miser_linesses
moderatenesses1764405moderatenesses
modernnesses1543865moder__nnesses
motherlinesses1962355mother_linesses
mutenesses1289975mute____nesses
nativenesses1548565nat__ivenesses
nattinesses11119325nat_ti__nesses
naturalness1153955natur_alne_s_s
neutralnesses1354355neutr_alnesses
ornerinesses1246575orneri__nesses
paltrinesses1445515paltri__nesses
patchinesses1944365patchi__nesses
patronesses1346475pat_r__onesses
poeticalnesses1853105poeticalnesses
prayerfulnesses2362405prayerfulnesses
radicalnesses16124145ra_dicalnesses
realnesses10310855____realnesses
regalnesses1246195__re_galnesses
retiringnesses1552485retiringnesses
savorinesses1544615savori__nesses
shrillnesses1543505__shrillnesses
statelinesses1344235stateli__nesses
sterlingnesses1553145_sterlingnesses
sternnesses1146635_ster__nnesses
stillnesses1146735_st__illnesses
straitnesses1246215_st_raitnesses
strictnesses1445415_st_rictnesses
tarrinesses11129085ta_rri__nesses
tastefulnesses1754605taste_fulnesses
tattinesses11128945tat_ti__nesses
tawdrinesses1643435tawdri__nesses
tearfulnesses1645535__tearfulnesses
tearinesses11311695__teari__nesses
tepidnesses1445385__tepi_dnesses
terriblenesses1694395__terriblenesses
tersenesses1149045__ter_senesses
tigerishnesses1852785tigerishnesses
trignesses1188215__t_ri_gnesses
trimnesses1287755__t_ri_mnesses
tritenesses11710395__t_ritenesses
typicalnesses2062545__typicalnesses
universalnesses1881925universalnesses
unnaturalnesses1561665unnatur_alnesses
utternesses1145875utter___nesses
vaporishnesses2252235vaporishnesses
variablenesses1965495va__riablenesses
verticalnesses1953675__verticalnesses
vitalnesses1456275vit___alnesses
wakefulnesses2354295wake_fulnesses
warinesses131514525wa__ri__nesses
wastefulnesses2054525waste_fulnesses
watchfulnesses2552985watchfulnesses
watercresses1752605water__cresses
wateriness1348075wateri__ne_s_s
waterishness1853265waterishne_s_s
waterlessnesses1754725waterlessnesses

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 Filter178691950240.356501941.0
2DLD Change Limit950241756.17315393.5
3Display Results1751750.1101590.9
 (SQL Overall)1786911756.63926915.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.