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

204 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
orality10111168(None) 
morality131110331morality
ovality1377591ovality
amorality1446722amorality
anality10313632anality
aurality1139222aurality
duality1147972duality
formality1746992formality
frailty1335662frailty
gravity1437182gravity
locality13148432locality
modality14117652modality
molality13118362molality
mortality1467732mortality
nodality12127422nodality
normality1447202normality
opacity1436312opacity
oralism9513762oralism
oralist7619632oralist
oralists8611802oralists
orally93113592oral_ly
quality1938562quality
rarity93615492_rarity
reality10313572reality
rurality1137402rurality
sodality12127322sodality
tonality1139792tonality
totality1139372totality
uralite71714102uralite
vocality16137932vocality
voracity1645532voracity
ability12311443ability
agility1148653agility
alit46155693__alit_
amity10416093__amity
anility10312723anility
arability14411013arability
aridity11510113aridity
atonality1247073atonality
axiality1856763axiality
banality1338763banality
boracite1249193boracite
brainy114815643bra_iny
bratty1159683bra_tty
brevity1534803brevity
brutality1444123brutality
carnality1447603carnality
cavity14310013_cavity
charity15311023charity
chirality1745453chirality
clarity12310913clarity
coalify1536683coalify
coevality1745383coevality
cordiality1645623cordiality
crafty14478913cra_fty
crazily2136923crazily
crudity1336043crudity
docility1447133docility
drafty13638933dra_fty
edacity1336373edacity
egalite8311563egalite
equality2046993equality
extrality1967203extrality
falsity1335913_falsity
fatality1438443fatality
fealty122910223feal_ty
feracity1646733feracity
finality1448343finality
fortuity1465573fortuity
fragility1645563fragility
frailly1337313frailly
frugality1653273frugality
fruity12429703fr_uity
gorblimy1641503gorblimy
gracility1546203gracility
grainy103914213gra_iny
granita82111303granita
granite82017083granite
gratify1436113gratify
gratuity1244283gratuity
halite93624233_halite
hyalite13229473hyalite
ideality1247153ideality
immorality1745213immorality
inanity1039503inanity
irreality1245413irreality
jollity1746143jollity
joviality2244133joviality
krait94726773kra_it_
kraits104912203kra_its
laity85318903_la_ity
laxity1637273_laxity
lealty92910603leal_ty
legality1237623legality
localite101411543localite
loyalty13114343loyal_ty
malty106721703_mal_ty
marlite92917083marlite
mobility1548543mobility
molarity13118903molarity
moralise10314913moralise
moralism12312363moralism
moralist10316663moralist
moralists11311103moralists
moralize19313923moralize
morally12411493moral_ly
mordacity1743513mordacity
moronity1347333moronity
morosity1347293morosity
motility1338733motility
nasality1146653nasality
natality1139193natality
nobility1348983nobility
nopalito1046063nopalito
nullity1037363nullity
oarlike113411193oarlike
obesity1275653obesity
odalisk1265373odalisk
oddity1135243o_ddity
oilily93111723o_ilily
oolite63319603o_olite
oolith93813243o_olith
oorali6311263oorali__
ooralis7312553oorali_s
opacify1743653opacify
opaline9412483opaline
oral47638123oral___
oralisms10610973oralisms
oralities91214123oralities
orals55826483oral__s
orangey11388833orangey
orangy105111233ora_ngy
orate55133303ora__te
orating83520323orating
oration71617713oration
oratory1039403oratory
orbit73622063or_bit_
orbits84211443or_bits
orology11319463orology
otalgy1035353otal_gy
otolith10108283otolith
outcity1238453outcity
outpity1237493outpity
ovally12278443oval_ly
oxalate1457623oxalate
oxalic1537093oxali_c
oxalis1339223oxali_s
ozalid1696683ozali_d
ozalids1794063ozalids
parity114719873_parity
penality13310713penality
plurality1444613plurality
polarity131310403polarity
polity113015863_polity
porosity1348593porosity
praline93019743praline
primality1687333primality
privity15268323privity
probity14299683probity
qualify2235473qualify
rabbity14266303_rabbity
racily11715173_racily
rainy85921083_ra_iny
raita54623073_ra_ita
rally84725903_ral_ly
ramify14268753_ramify
rarify123210063_rarify
ratify122610043_ratify
ratite65022423_ratite
ratty84819593_ra_tty
raucity1235853_raucity
realty92713693real_ty
regality1249313regality
relit55340683_relit_
royalty13165113royal_ty
ruralite848963ruralite
salify12311373_salify
salty85524383_sal_ty
sanity9316203_sanity
sociality1447953sociality
sodalite9109593sodalite
sorority1146903sorority
spirality1446433spirality
suavity1336323suavity
torosity1147243torosity
trait56940843tra_it_
traits65121983tra_its
trilith10310513trilith
trinity10310843trinity
unmorality1554323unmorality
unreality1246323unreality
uralites82112723uralites
uralitic10158463uralitic
uranite72515693uranite
urbanity13105303urbanity
urolith1048783urolith
utility1038713utility
vanity12311943_vanity
varsity1356673varsity
venality1438683venality
veracity1647553veracity
virility1447743virility
vitality1458113vitality
wraith1258603wra_ith

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 Filter1786911340270.453394461.4
2DLD Change Limit1340272047.72017361.0
3Display Results2042040.0762684.2
 (SQL Overall)1786912048.24921662.1
 
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.