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

172 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
oddity113524(None) 
deity94316772_deity
nudity1037992nudity
oddish11107652oddish
oddly1037162odd_ly
acidity1338593acidity
acuity1139373acuity
addict10711203addict
addicts1176013addicts
adding93914963adding
additory1344263additory
adit56443653_adit_
adits66523713_adits
admit8319493admit_
admits9411413admits
amity10416093_amity
aridity11510113aridity
audit62527883audit_
audits72814113audits
avidity1436483avidity
bedirty1344183bedirty
bodily12310993bodily
cavity14310013cavity
cecity1398153cecity
city95122623__city
codding124014693codding
codify1537163codify
coedit9316243coedit_
coedits10310243coedits
comity13312713comity
cordite10315263cordite
crudity1336043crudity
daily95922333_daily
dainty105311473_dainty
dairy97016303_dairy
daisy95915313_daisy
deify124112763_deify
dicty115116293_dicty
didy99121513__didy
dimity12310473dimity
dirty95617803_dirty
dit47071333__dit_
dita56032523__dita
dite55547553__dite
dits56450523__dits
ditsy95612563__ditsy
ditty95019293_ditty
ditz146929513__ditz
ditzy186513283__ditzy
doddery13516853doddery
dodgy116611463dod_gy
doily95321033_doily
doit56347853_doit_
doits66223673_doits
dopily123510463dopily
dorty96220813_dorty
dotty94516103_dotty
doty86128223__doty
dowdily1534953dowdily
dozily19329103dozily
drifty13418223_drifty
drily95816523_drily
duit56241583_duit_
duits65021883_duits
dusty96018323_dusty
duty85321453__duty
edacity1336373edacity
eddied9248323eddied
eddies83313163eddies
eddy93912093edd__y
edgily1136063edgily
edify12308563_edify
edit54934863_edit_
edits65819033_edits
endite73817593endite
enmity1137483enmity
entity9312053entity
equity1838103equity
ferity122813343ferity
fixity19427803fixity
fruity12429693fruity
giddily1335073giddily
godding113911943godding
godlily1235343godlily
godwit1137513godwit_
godwits1234133godwits
gordita945093gordita
hadith13312063hadith
hoddin11369943hoddi_n
hoddins12289373hoddins
indite73520323indite
jollity1746143jollity
laity85318903_laity
laxity1637273laxity
lenity9612713lenity
levity1277903levity
lyddite1243333lyddite
mity95528213__mity
modality14117653modality
modesty13476983modesty
modify1537173modify
moodily1358203moodily
muddily1435963muddily
nidify1336763nidify
nodality12127423nodality
noddies93512043noddies
nodding103811523nodding
noddy105411203nodd__y
nodosity1254923nodosity
obesity1275653obesity
obit66837083o_bit_
obits74617553o_bits
odd57725453odd___
odder74515393odd_er
oddest81710863oddest
oddities1046603oddities
odds68919923odd__s
odic74920573o_di_c
odist6421913o_dist
odists749853odists
odium83413033o_dium
oidia6314953oidi_a
oidium959813oidium
oilily93111723oilily
oily77932253o__ily
oldie6415473oldi_e
oldies7314423oldies
oldish10169313oldish
oldy85316843old__y
omit65337373o_mit_
omits75018263o_mits
oolite63319603oolite
oolith93813243oolith
oozily18328073oozily
opacity1436313opacity
ophite11410563ophite
orality101111683orality
orbit73622063orbit_
orbits84211443orbits
ossify1244973ossify
outcity1238453outcity
outpity1237493outpity
ovality1377593ovality
parity114719873parity
pity96031933__pity
podding124113183podding
podgily1435213podgily
podite93315353podite
polity113015863polity
purity114114913purity
quiddity2242693quiddity
rarity93615493rarity
rodding103814533rodding
rowdily1436083rowdily
ruddily1236303ruddily
sanity9316203sanity
shoddily1643573shoddily
sodality12127323sodality
soddies92312853soddies
sodding103712733sodding
soddy104210703sodd__y
solidity1248113solidity
tidily102811393tidily
toddies93011993toddies
toddy106812423todd__y
unity84918493_unity
uppity1335103uppity
vanity12311933vanity
verity123714853verity
viduity1445343viduity
whity145513473_whity
wordily1437853wordily

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 Filter1786911127160.376475242.0
2DLD Change Limit1127161725.68619823.4
3Display Results1721720.0463739.1
 (SQL Overall)1786911726.10829255.2
 
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.