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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

77 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
essentialities147324(None) 
essentializes2263482essentiali_zes
essentialisms1563273essentiali_sms
essentialists1363063essentiali_sts
essentiality1563503essentialit__y
essentialize2163763essentiali_ze_
essentialized2363263essentiali_zed
essentializing2462893essentializing
eventualities1653513e_ventualities
potentialities1674203potentialities
bestialities1455494__bestialities
centralities1448624__centralities
dentalities1249544__dent_alities
effectualities2262204effectualities
erectilities1447124e_recti_lities
essentialism1463394essential__ism
essentialist1263874essential__ist
essentialness1363264essential_ness
essentialnesses1462644essentialnesses
essentials1054584essential____s
genialities12148644__gen_ialities
gentilities1249134__genti_lities
mentalities13410024__ment_alities
sectilities1348694__secti_lities
senilities10312994__sen_i_lities
sensualities1265944__sensualities
spatialities1465564__spatialities
specialities1656794_spe_cialities
venialities14168934__ven_ialities
asexualities1994575_ase_xualities
bisexualities22103635bise_xualities
congenialities1774195congen_ialities
disutilities1355155dis_uti_lities
eccentricities1792165eccentricities
effectivities2453855effecti_vities
ephemeralities2171785ephemeralities
essential946085essential_____
essentially1455125essential___ly
etherealities1653695ethe_realities
extensibilities2493465extensibilities
externalities2055185exte_rnalities
extralities1848235___extralities
fertilities1448825__ferti_lities
frontalities1555575_front_alities
generalities1347015__generalities
hospitalities1854125hospit_alities
hostilities14127655hos__ti_lities
impartialities1863495impartialities
infantilities1665265infanti_lities
infertilities1656215inferti_lities
insensibilities1764915insensibilities
juvenilities2252725juven_i_lities
lethalities1446415__le_thalities
materialities1566395mate_rialities
neutralities1246465__neutralities
nuptialities1454785__nuptialities
partialities14108035__partialities
penalities121313475__pen__alities
personalities1556475person__alities
retentivities1654545retenti_vities
seasonalities1353575season__alities
selectivities1854875selecti_vities
seniorities1148125__sen_iorities
sensibilities1557375__sensibilities
septicities1547315__septi_cities
serendipities1662625serendi_pities
servilities1447055__servi_lities
sessilities1146405__sessi_lities
sexualities1857405__se_xualities
socialities1349295__s_ocialities
specialties1544665_spe_cial_ties
sterilities11129015_ste_ri_lities
subtilities1347855__subti_lities
tensilities1147655__tensi_lities
venalities131510725__ven__alities
versatilities1656085vers_ati_lities
verticalities1885215__verticalities

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.360496363.9
2DLD Change Limit95024775.92316043.2
3Display Results77770.0461673.9
 (SQL Overall)178691776.32928233.7
 
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.