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

48 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
inviolatenesses1892801inviolatenesses_
inviolateness1693203inviolatene_s_s_
inchoatenesses1953594incho_atenesses_
intimatenesses1655024inti_matenesses_
animatenesses1555945an_i_matenesses_
desolatenesses1553975_desolatenesses_
impolitenesses1853955i_mpolitenesses_
inanimatenesses1762745inanimatenesses_
infinitenesses1795035infi_nitenesses_
innatenesses1247185in___natenesses_
insatiatenesses1593485insatiatenesses_
intricatenesses1763315intricatenesses_
inviolableness19104535inviolablene_s_s_
invisiblenesses2094215invisiblenesses_
violablenesses1984735__violablenesses_
absolutenesses1662406_absolutenesses_
dilutenesses1346116__di_lutenesses_
dissolutenesses1561996dissolutenesses_
elaboratenesses1762046elaboratenesses_
enviablenesses1965926envi_ablenesses_
enviousnesses1647886envio__usnesses_
finitenesses1557726fin_i___tenesses_
idiomaticnesses2071056i_diomaticnesses_
immediatenesses2062186immediatenesses_
inanenesses1149526in____anenesses_
inchoateness1754136incho_atene_s_s_
incisivenesses1966686inci_sivenesses_
indirectnesses1762166indirect_nesses_
initialnesses1395616in_itia_lnesses_
insanenesses1246876in___sanenesses_
insolublenesses1763436in_solublenesses_
intimateness1455796inti_matene_s_s_
invasivenesses2056026inv_asivenesses_
invectivenesses23106016invectivenesses_
inventivenesses21136256inventivenesses_
invidiousnesses1955016invidiousnesses_
iratenesses11411446___i_ratenesses_
latenesses10413366_____latenesses_
oblatenesses1475776___oblatenesses_
obsoletenesses1662226_obsoletenesses_
politenesses1448596___politenesses_
privatenesses1855346_pri_vatenesses_
resolutenesses1493496_resolutenesses_
sveltenesses1545236_sv_el_tenesses_
ultimatenesses1652996ulti_matenesses_
vilenesses13310226__vi_l__enesses_
villainesses1543516__villa_inesses_
volatilenesses1754476__v_olatilenesses_

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.0931921408.6
2DLD Change Limit65874485.42312147.2
3Display Results48480.0301600.0
 (SQL Overall)178691485.54632219.8
 
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.