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

138 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
morality13111033(None) 
amorality1446721amorality
modality14117651modality
molality13118361molality
mortality1467731mortality
orality101111681_orality
aurality1139222aurality
formality1746992formality
immorality1745212immorality
locality13148432locality
mobility1548542mobility
molarity13118902molarity
moralise10314912moralise
moralism12312362moralism
moralist10316662moralist
moralists11311102moralists
moralize19313922moralize
morally12411492moral_ly
mordacity1743512mordacity
moronity1347332moronity
morosity1347292morosity
motility1338732motility
nodality12127422nodality
normality1447202normality
ovality1377592_ovality
rurality1137402rurality
sodality12127322sodality
tonality1139792tonality
totality1139372totality
unmorality1554322unmorality
vocality16137932vocality
voracity1645532voracity
amoralism1347953amoralism
amorally1348093amoral_ly
anality10313633_anality
atonality1247073atonality
axiality1856763axiality
banality1338763banality
bimodality1852763bimodality
boracite1249193boracite
carnality1447603carnality
chirality1745453chirality
coalify1536683co_alify
coevality1745383coevality
cordiality1645623cordiality
docility1447133docility
duality1147973_duality
equality2046993equality
extrality1967203extrality
fatality1438443fatality
feracity1646733feracity
finality1448343finality
fortuity1465573fortuity
frailty1335663_frailty
gorblimy1641503gorblimy
gravity1437183_gravity
ideality1247153ideality
immortality1873793immortality
irreality1245413irreality
jollity1746143jo_llity
joviality2244133joviality
legality1237623legality
localite101411543localite
loyalty13114343loyal_ty
malty106721703m__al_ty
mammality1544283mammality
marlite92917083mar_lite
mayoralty1752213mayoral_ty
megacity1645713megacity
megalith1448243megalith
mentality1449133mentality
minacity1547373minacity
modally1338403modal_ly
mohalim1446033mohali_m
mollify1555503mo_llify
monazite1957083monazite
monolith1349673monolith
moonlit9229333moonlit_
moraine9314573mora_ine
moral75533433moral___
morale85220553moral__e
morales93619403moral_es
moralised1239663moralised
moralises11314003moralises
moralisms13410293moralisms
moralistic1446803moralistic
moralities121111923moralities
moralized21310753moralized
moralizer2049473moralizer
moralizes20312863moralizes
morals85324643moral__s
morassy12495043mora_ssy
moratory1347823moratory
moray105423793mora___y
morbidity1744143morbidity
morganite1247423morganite
mortally1339933mortal_ly
mortify1536223mor_tify
motivity1646233motivity
movability2077233movability
muralist10312983muralist
muralists1148163muralists
mutuality1444743mutuality
nasality1146653nasality
natality1139193natality
nobility1348983nobility
nopalito1046063nopalito
oorali6311263oorali__
ooralis7312553oorali_s
opacity1436313_opacity
oralism9513763_oralism
oralist7619633_oralist
oralists8611803_oralists
orally93113593_oral_ly
osmolality1553153osmolality
penality13310713penality
plurality1444613plurality
polarity131310403polarity
polity113015863po__lity
porosity1348593porosity
quality1938563_quality
rarity93615493__rarity
reality10313573_reality
regality1249313regality
royalty13165113royal_ty
ruralite848963ruralite
sociality1447953sociality
sodalite9109593sodalite
sorority1146903sorority
spirality1446433spirality
temporality1853673temporality
torosity1147243torosity
unreality1246323unreality
uralite71714103_uralite
venality1438683venality
veracity1647553veracity
virility1447743virility
vitality1458113vitality

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.406440125.6
2DLD Change Limit1461621387.08020644.4
3Display Results1381380.0463000.0
 (SQL Overall)1786911387.53223724.2
 
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.