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

114 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
odorize173740(None) 
odorized1945841odorized
odorizes1837211odorizes
colorize192314202colorize
deodorize2045272deodorize
idolize1737782idolize
motorize19410432motorize
oorie53026362o_ori_e
ozonize1546292ozonize
sodomize20135252sodomize
adore65723673ador__e
adoring9412523adoring
adoze155713833ado__ze
agonize172911403agonize
amortize1987743amortize
anodize1738683anodize
aphorize2249043aphorize
apprize2038183apprize
arborize1988963arborize
atomize183111823atomize
azotize1537083azotize
boride9415903_boride
bromize20238823bromize
calorize192712733calorize
chorine123218363chorine
chorizo2136323chorizo
coderive1447693coderive
codrive1337653cod_rive
colonize192312773colonize
colorized212211773colorized
colorizer202410623colorizer
colorizes203014523colorizes
comprize2368733comprize
deodorized2244893deodorized
deodorizer2144183deodorizer
deodorizes2145363deodorizes
deride84420033_deride
derive103817043_derive
diorite8314913diorite
dobie84920333_dobi_e
docile94213123_docile
dogie75222793_dogi_e
domine92918253_domine
doobie94712683doobi_e
doolie73916833dooli_e
doozie163910653doozi_e
dore56353303_dor__e
dories75232363_dories
dormice1237133_dormice
dormie9312623_dormie
dourine8311453dourine
dowie94721143_dowi_e
doxie136017153_doxi_e
doze145829083_do__ze
drive95318003_d_rive
ebonize1838153ebonize
emprize2038843emprize
erotize16311663erotize
exorcize2644893exorcize
heroize193210963heroize
idolise839293idolise
idolized1946003idolized
idolizer1845663idolizer
idolizes1837553idolizes
iodize164112593_iodize
ionize154613873_ionize
ironize16610373ironize
lionize1668823lionize
maderize2049073maderize
memorize211311103memorize
modernize2144383modernize
motorise10311523motorise
motorized2148663motorized
motorizes20410783motorizes
norite63221133_norite
notarize1749293notarize
obelize1838243obelize
odonate848403odonate
odor55718093odor___
odorant8411393odorant
odored8399223odor_ed
odorful1143483odorful
odorizing2046113odorizing
odorous837663odorous
odors64514283odor__s
oolite63319603o_olite
ooze136420603o_o__ze
opsonize19114993opsonize
oroide7311703oro_ide
orrice81410163o_rrice
ourie54027303o_uri_e
outride82615683outride
outsize162411753outsize
oversize201812513oversize
oxidize2444983oxidize
ozonide1754963ozonide
ozonise1646443ozonise
ozonized1745113ozonized
ozonizer1654473ozonizer
ozonizes1636083ozonizes
podzolize2042373podzolize
polarize19512653polarize
prize164718943__prize
robotize1945693robotize
scoriae9310903scoriae
soberize1998883soberize
sodomite11136913sodomite
sodomized22124463sodomized
sodomizes21125663sodomizes
solarize17511473solarize
theorize2047073theorize
thorite10313443thorite
valorize20239613valorize
vaporize22239173vaporize

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271146.95319276.1
3Display Results1141140.0462478.3
 (SQL Overall)1786911147.40524131.1
 
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.