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

113 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
modality1411765(None) 
molality13118361molality
morality131110331morality
nodality12127421nodality
sodality12127321sodality
amorality1446722amorality
bimodality1852762bimodality
locality13148432locality
mobility1548542mobility
modally1338402modal_ly
molarity13118902molarity
mordacity1743512mordacity
mortality1467732mortality
motility1338732motility
orality101111682_orality
ovality1377592_ovality
sodalite9109592sodalite
tonality1139792tonality
totality1139372totality
vocality16137932vocality
anality10313633_anality
atonality1247073atonality
audacity1444823audacity
aurality1139223aurality
axiality1856763axiality
banality1338763banality
coalify1536683co_alify
coevality1745383coevality
cordiality1645623cordiality
docility1447133docility
duality1147973_duality
edacity1336373_edacity
equality2046993equality
fatality1438443fatality
feudality1654403feudality
fidelity1544933fidelity
finality1448343finality
formality1746993formality
godlily1235343god_lily
ideality1247153ideality
immorality1745213immorality
jollity1746143jo_llity
joviality2244133joviality
legality1237623legality
localite101411543localite
loyalty13114343loyal_ty
malty106721703m__al_ty
mammality1544283mammality
medaling121912263medaling
medalist11414213medalist
medalists1249373medalists
megacity1645713megacity
megalith1448243megalith
mendacity1744153mendacity
mentality1449133mentality
minacity1547373minacity
modal85919243modal___
modalities13138813modalities
modals93914463modal__s
modeling12311073modeling
modelist11310503modelist
modelists1246473modelists
modernity1543533modernity
modesty13476983mod_esty
modify1537173mod__ify
modularity1663323modularity
modulate1138593modulate
moduli9267963moduli__
mohalim1446033mohali_m
mollify1555503mo_llify
monazite1957083monazite
monolith1349673monolith
moonlit9229333moonlit_
moralise10314913moralise
moralism12312363moralism
moralist10316663moralist
moralists11311103moralists
moralize19313923moralize
morally12411493moral_ly
moronity1347333moronity
morosity1347293morosity
motivity1646233motivity
movability2077233movability
mundanity1543523mundanity
mutuality1444743mutuality
nasality1146653nasality
natality1139193natality
nobility1348983nobility
nodally1137913nodal_ly
nodosity1254923nodosity
nopalito1046063nopalito
normality1447203normality
odalisk1265373_odalisk
oddity1135243_od_dity
opacity1436313_opacity
osmolality1553153osmolality
penality13310713penality
polarity131310403polarity
polity113015863po__lity
quality1938563_quality
reality10313573_reality
regality1249313regality
royalty13165113royal_ty
rurality1137403rurality
sedulity1245843sedulity
sociality1447953sociality
sodalist9311883sodalist
sodalists1038153sodalists
sodalites10128693sodalites
unmorality1554323unmorality
venality1438683venality
vitality1458113vitality
voracity1645533voracity

Search took 9 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 Limit1461621137.50019488.3
3Display Results1131130.0601883.3
 (SQL Overall)1786911137.98322383.9
 
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.