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

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

118 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
penality1331071(None) 
penalty1267741penal_ty
venality1438681venality
anality10313632_anality
banality1338762banality
dentality1348472dentality
finality1448342finality
geniality1347162geniality
legality1237622legality
mentality1449132mentality
penalise101013762penalise
penalize19912752penalize
penally121111772penal_ly
penlite9313242pen_lite
reality10313572re_ality
regality1249312regality
senility1139682senility
tenacity1347112tenacity
tonality1139792tonality
veniality1547592veniality
anility10312723_anility
atonality1247073atonality
aurality1139223aurality
axiality1856763axiality
bipedality1852783bipedality
carnality1447603carnality
centrality1547743centrality
coevality1745383coevality
debility1448643debility
denazify2442533denazify
density1137593den_sity
duality1147973_duality
edacity1336373_edacity
egalite8311563_egalite
enmity1137483_en_mity
entity9312053_en_tity
equality2046993equality
fatality1438443fatality
fealty122910223fe_al_ty
feracity1646733feracity
feudality1654403feudality
generality1446193generality
gentility1347063gentility
ideality1247153ideality
inanity1039503_inanity
lealty92910603le_al_ty
lenity9612713len__ity
lethality1545113lethality
lineality1246423lineality
locality13148433locality
megacity1645713megacity
megalith1448243megalith
mendacity1744153mendacity
mesnalty1343423mesnal_ty
minacity1547373minacity
modality14117653modality
molality13118363molality
morality131110333morality
nasality1146653nasality
natality1139193natality
nodality12127423nodality
openability1846933openability
orality101111683_orality
ovality1377593_ovality
parity114719873p__arity
pealike131211273pe_alike
pealing104123203pe_aling
pearlite1039443pearlite
peaty105725693pe_a__ty
pedalier1137603pedalier
pedaling122412133pedaling
pelite84323003pe__lite
penal75228373penal___
penalised12108833penalised
penalises11912773penalises
penalities121313473penalities
penalized211210243penalized
penalizes20911853penalizes
penalties11139513penalties
penlites10312273pen_lites
penology14238483penology
penult8314653penul_t_
penults937123penul_ts
perlite9317323pe_rlite
personality1656333personality
petaline10314883petaline
petalody1443873petalody
phenacite1686103phenacite
phenakite1864233phenakite
planarity1445323planarity
plenarily1444673plenarily
plurality1444613plurality
polarity131310403polarity
polity113015863p__olity
predacity1745603predacity
primality1687333primality
puerility1445993puerility
pugnacity1742563pugnacity
quality1938563_quality
realty92713693re_al_ty
rurality1137403rurality
sedulity1245843sedulity
sensuality1344433sensuality
sexuality1946073sexuality
sodality12127323sodality
speciality1746333speciality
spirality1446433spirality
tenability1549123tenability
tensility1245813tensility
tensity1039103ten_sity
tenuity1037453ten_uity
totality1139373totality
venally13119563venal_ly
venosity1446023venosity
veracity1647553veracity
vitality1458113vitality
vocality16137933vocality
xenolith1845653xenolith

Search took 8 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621186.85621318.8
3Display Results1181180.0502360.0
 (SQL Overall)1786911187.32924381.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.