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

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

46 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
penitences144797(None) 
penitence1348091penitence_
renitences1248451renitences
impenitences1854022impenitences
leniences1148152leni_ences
penitents1147702peniten_ts
pentenes10315632pen_ten_es
renitence1149062renitence_
renitencies1346092renitencies
sentences11610302sen_tences
sentiences1247602sentiences
desinences1347223desinences
eminences1347413_eminences
ententes8312773_en_tentes
evidences1556343_evidences
exigences1946333_exigences
existences1944823_existences
hesitances1545543hesitances
impenitence1754023impenitence_
lenience1048343leni_ence_
leniencies1246193leni_encies
patiences1367433pati_ences
penances12312443pen__ances
pendencies1547023pen_dencies
penetrances1544803penetrances
penitent10413503peniten__t
penitently1545933penitently
pentanes10316083pen_tan_es
pentene9313793pen_ten_e_
persistences1653863persistences
pertinences1545753pertinences
pestilences1544693pestilences
petiteness1248493petiteness
potences12710693p__otences
pretences132312613p_retences
renitency1445443renitenc_y
residences1368243residences
reticences1447463reticences
sentence1099863sen_tence_
sentenced1256683sen_tenced
sentencer1156383sen_tencer
sentencers1274783sen_tencers
sentience1147663sentience_
sentiencies1346323sentiencies
tendences1248083ten_dences
tenpences1346543ten_pences

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 Filter1786911406030.406440125.6
2DLD Change Limit140603466.09323076.2
3Display Results46460.0162875.0
 (SQL Overall)178691466.51527427.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.