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

240 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
oddish1110765(None) 
oldish10169311oldish
caddish143810122caddish
cloddish1544232cloddish
codfish1637162codfish
coldish1399302coldish
dish86328332__dish
dovish1338102dovish
dudish1148312dudish
faddish15359002faddish
goodish1237962goodish
jadish17319902jadish
kaddish16317972kaddish
kiddish16276582kiddish
laddish12299722laddish
loudish1137982loudish
maddish14289482maddish
modish123813542modish
oafish121311722oafish
oddest81710862oddest
oddity1135242oddity
odds68919922odd_s_
odist6421912o_dist
offish15137272offish
ogrish1039262ogrish
owlish1238702owlish
radish103516912radish
reddish1238032reddish
toadish1139062toadish
widish13419362widish
addict10711203addict
adding93914963adding
adds67622453add_s_
advise10139223advise
aguish1059283aguish
apish105116633_apish
aspish114810333aspish
baldish1339503baldish
banish111416043banish
bidis86721143bidis_
blondish1476173blondish
bluish1159243bluish
boarish123911913boarish
boggish14238653boggish
boobish14338943boobish
bookish163610023bookish
boorish123712593boorish
boxfish2285543boxfish
boyish142911233boyish
broadish1446933broadish
caddis104613383caddis_
cadis84428503cadis_
cedis84317083cedis_
cockish1838503cockish
codding124014693codding
coltish121310933coltish
coolish12312523coolish
cowfish1836433cowfish
coyish143710393coyish
cuish10313173_cuish
dais57040703_dais_
daisy95915313_daisy
danish101513793danish
dash87031633__dash
deash95617243_deash
deism84116033_deism
deist64633593_deist
delish105215613delish
didst74619613_didst
dis46459893__dis_
disc76123233__disc
dishy125712353__dishy
disk96625833__disk
diss56434483__diss
dodoism1135893dodoism
dodos75819393dodos_
dogfish15226763dogfish
doggish13237533doggish
dollish11610093dollish
doltish11118733doltish
donnish11187633donnish
dowdyish1952833dowdyish
dryish1336323dryish
eddied9248323eddied
eddies83313163eddies
elfish1267963elfish
elvish1277563elvish
emdash12244113emdash
endash10297123endash
faddism14356723faddism
faddist12289643faddist
famish14311843famish
fetish12310373fetish
finish124613413finish
fish106926273__fish
fluish1239333fluish
fogyish1735363fogyish
folkish1736563folkish
foolish1339613foolish
foppish1735103foppish
foxfish2354483foxfish
gaddis94211373gaddis_
gadis74825293gadis_
garish104516923garish
goatish1139563goatish
goddess1035263goddess
godding113911943godding
goldfish1644203goldfish
goyish13379013goyish
hadith13312063hadith
hoddin11369943hoddi_n
hoddins12289373hoddins
hogfish17257023hogfish
hoggish15247593hoggish
hottish13117903hottish
impish13499193impish
iodids83711153iodids_
iodise74214943iodise
iodism93611133iodism
kadis105921063kadis_
kiddush16242483kiddush
knish1238603_knish
ladyish14287823ladyish
latish92416173latish
lavish124112983lavish
loggish12258723loggish
longish11229093longish
loutish1039963loutish
lowish12310533lowish
maidish13239553maidish
marish114319053marish
midis85923413midis_
minish115216303minish
mobbish1635923mobbish
monish114217593monish
monkish1638243monkish
moonish123311043moonish
moorish123311783moorish
mopish134311593mopish
mudfish1646263mudfish
mulish11311903mulish
nerdish1137103nerdish
newish1237903newish
noddies93512043noddies
nodding103811523nodding
noirish1037883noirish
nourish1039703nourish
nudism9357913nudism
nudist73813323nudist
oarfish13158613oarfish
oasis56422553oasis_
obiism1036363obiism
obis66226843o_bis_
oboist8312683oboist
odah87018933o_d_ah
odahs95610083odahs_
odalisk1265373odalisk
odas57230263o_das_
odd57725453odd___
odder74515393odd_er
oddly1037163odd_ly
oddness935313oddness
odes57243243o_des_
odic74920573o_di_c
odists749853o_dists
odium83413033o_dium
odors64514283odors_
ods47546213o_d_s_
odyls9428653odyls_
ogreish1134673ogreish
ogrism937913ogrism
oidia6314953oidi_a
oidium959813oidium
oldest72114093oldest
oldie6415473oldi_e
oldies7314423oldies
olds55926573old_s_
onrush935343onrush
oolith93813243oolith
ordos65216203ordos_
orisha936773o_risha
ornis54616773ornis_
orris54516553orris_
ouds56430103oud_s_
outfish132210573outfish
outwish13289853outwish
oxidise1545043oxidise
oxids13128963oxids_
padis86227143padis_
palish114718273palish
parish115022353parish
perish114619063perish
pish96127913__pish
podding124113183podding
polish114916723polish
poorish123712303poorish
popish133812113popish
prudish1376563prudish
punish111411503punish
qadis155917853qadis_
rakish134313963rakish
ravish123414033ravish
rawish123012913rawish
redfish1437793redfish
relish93916953relish
rodding103814533rodding
roguish1156833roguish
rompish1436693rompish
roundish1246253roundish
rowdyish1852663rowdyish
sadis64930853sadis_
sadism94113493sadism
sadist74221353sadist
soddies92312853soddies
sodding103712733sodding
softish13127813softish
sottish10129443sottish
sourish10310693sourish
squish1838573squish
swish115114823_swish
toadfish1544903toadfish
toadyish1544153toadyish
toddies93011993toddies
tonish93415903tonish
tonnish10149093tonnish
townish13167933townish
toyish122911123toyish
tundish1137283tundish
unwish1239093unwish
uppish1336633uppish
vanish121513213vanish
voguish1465203voguish
wadis95223963wadis_
whish144512923_whish
wildish1446853wildish
winish124212263winish
wish107228733__wish
woggish15276673woggish
wolfish1636933wolfish
wormish1537163wormish

Search took 6 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.373479064.3
2DLD Change Limit1127162404.64324276.5
3Display Results2402400.0932580.6
 (SQL Overall)1786912405.10934975.7
 
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.