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

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

47 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
customarinesses1961301customarinesses_
customariness1761573customarine_s_s_
contrarinesses1674245cont_rarinesses_
cursorinesses1553295curso__rinesses_
customaries1553735customari____es_
untowardnesses1862335_untowardnesses_
visionarinesses1861665visionarinesses_
austerenesses1354176aust__erenesses_
bustinesses131310096bust____inesses_
charinesses1639566c____harinesses_
comelinesses1666406c___omelinesses_
comfinesses1846916c___om_finesses_
costlinesses1446256cost___linesses_
crustinesses14137636crust____inesses_
cushinesses16127416cus____hinesses_
customises1444806custom__i___ses_
dustinesses121110356dust____inesses_
fustinesses14129786fust____inesses_
gustinesses12139526gust____inesses_
hoarinesses14310226___ho_arinesses_
literarinesses1483356_literarinesses_
lustinesses11910426lust____inesses_
mustinesses131010416must____inesses_
outwardnesses1752616ou_t_wardnesses_
pastoralnesses1653136pastora_lnesses_
rustinesses11911556rust____inesses_
scarinesses1339906__s__carinesses_
smarminesses1645106__s__marminesses_
smartnesses1337146__s__martnesses_
soapinesses1339716__s_o_apinesses_
sorrinesses11310096__s_o_rrinesses_
staginesses1238466__st__aginesses_
starknesses1545886__st__arknesses_
steadinesses1346906__st_eadinesses_
steaminesses1446226__st_eaminesses_
stockinesses1844506__sto_ckinesses_
stodginesses1443946__sto_dginesses_
stoninesses1138256__sto__ninesses_
storminesses1445036__sto_rminesses_
streakinesses1743636__streakinesses_
sultrinesses1245886sult___rinesses_
tearinesses11311696___t_earinesses_
temporarinesses1961986temporarinesses_
ultimatenesses1652996_ultimatenesses_
unsteadinesses1553066unst_eadinesses_
untimelinesses16103186_untimelinesses_
unwarinesses1546156_u__nwarinesses_

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 Filter178691658740.313570897.8
2DLD Change Limit65874475.01613132.8
3Display Results47470.0301566.7
 (SQL Overall)178691475.35933344.1
 
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.