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

302 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
oldish1016931(None) 
coldish1399301coldish
oddish11107651oddish
baldish1339502baldish
bluish1159242bluish
coltish121310932coltish
dish86328332__dish
dollish11610092dollish
doltish11118732doltish
dudish1148312dudish
elfish1267962elfish
elvish1277562elvish
fluish1239332fluish
folkish1736562folkish
goldfish1644202goldfish
goodish1237962goodish
jadish17319902jadish
loudish1137982loudish
lowish12310532lowish
modish123813542modish
oafish121311722oafish
odist6421912o_dist
offish15137272offish
ogrish1039262ogrish
oldest72114092oldest
oldie6415472oldi_e
oldies7314422oldies
olds55926572old_s_
owlish1238702owlish
polish114916722pol_ish
radish103516912radish
toadish1139062toadish
widish13419362widish
wildish1446852wildish
wolfish1636932wolfish
abolish12311503abol_ish
aguish1059283aguish
aldose7311093aldose
alist56136783al_ist
apish105116633_apish
aspish114810333aspish
banish111416053banish
bidis86721143bidis_
blandish1497003blandish
blemish1436603blemish
bliss75616913bl_iss
blondish1476173blondish
blueish1236483blueish
blush105115313bl_ush
boarish123911913boarish
boggish14238653boggish
boldest102613063boldest
bolds85825283bold_s_
boobish14338943boobish
bookish163610023bookish
boorish123712593boorish
boxfish2285543boxfish
boyish142911233boyish
broadish1446933broadish
bullish12511193bullish
caddish143810133caddish
cadis84428503cadis_
cedis84317083cedis_
childish1744393childish
cladism1238553cladism
cladist10311973cladist
clash106219033cl_ash
clayish1547943clayish
cloddish1544233cloddish
coalfish1635493coalfish
cockish1838503cockish
codfish1637163codfish
coldest102514763coldest
colds85726973cold_s_
coolish12312523coolish
cowfish1836433cowfish
coyish143710393coyish
cuish10313173_cuish
cultish12139113cultish
danish101513803danish
dash87031633__dash
delish105215613delish
dis46459893__dis_
disc76123233__disc
dishy125712353__dishy
disk96625833__disk
diss56434483__diss
dogfish15226763dogfish
doggish13237533doggish
donnish11187633donnish
dovish1338103dovish
dowdyish1952833dowdyish
dryish1336323dryish
dullish1148743dullish
eldest72912683eldest
eldrich1354583eldrich
elds56324853eld_s_
emdash12244113emdash
endash10297123endash
eolith93013903eol_ith
faddish15359003faddish
famish14311843famish
fetish12310373fetish
finish124613413finish
fish106926273__fish
flash115716213fl_ash
flemish1536373flemish
flesh115013743fl_esh
flush115116073fl_ush
fogyish1735363fogyish
folding123912443folding
folds95221693fold_s_
follis93113903follis_
foolfish1744393foolfish
foolish1339613foolish
foppish1735103foppish
foxfish2354483foxfish
gadis74825293gadis_
garish104516923garish
goatish1139563goatish
goldest92411173goldest
golds75421313gold_s_
golosh1036463gol_osh
goyish13379013goyish
hadith13312063hadith
hellish13310723hellish
hogfish17257023hogfish
hoggish15247593hoggish
holding123514283holding
holds94623243hold_s_
holism113713753hol_ism
holist94723213hol_ist
hottish13117903hottish
impish13499193impish
iodise74214943iodise
iodism93611133iodism
kaddish16317973kaddish
kadis105921063kadis_
kiddish16276583kiddish
knish1238603_knish
laddish12299723laddish
ladyish14287823ladyish
laich105920713_laich
laigh95515923_laigh
laith85722103_laith
lash76539653_l_ash
latish92416173latish
lavish124112983lavish
leash85519213_leash
leis45739603_leis_
lich96230843_l_ich
lids56336463_lids_
lis37162273_l_is_
lisp68926883_l_isp
list47055343_l_ist
lodes66436913lodes_
loggish12258733loggish
loids66220703loids_
longish11229093longish
loris55329153loris_
louis57322323louis_
loutish1039963loutish
lush75327693_l_ush
maddish14289483maddish
maidish13239553maidish
marish114319053marish
midis85923413midis_
minish115216303minish
mobbish1635923mobbish
moldier103110033moldier
moldiest11249693moldiest
molding114213753molding
molds85324833mold_s_
monish114217593monish
monkish1638243monkish
moonish123311043moonish
moorish123311783moorish
mopish134311593mopish
mudfish1646263mudfish
mulish11311903mulish
nerdish1137103nerdish
newish1237903newish
noirish1037883noirish
nourish1039703nourish
nudism9357913nudism
nudist73813323nudist
oarfish13158613oarfish
oasis56422553oasis_
obiism1036363obiism
obis66226843o_bis_
oboist8312683oboist
odah87018933o_d_ah
odahs95610083o_dahs
odas57230263o_das_
oddest81710863oddest
oddity1135243oddity
odds68919923o_dds_
odes57243243o_des_
odic74920573o_di_c
odists749853o_dists
odium83413033o_dium
ods47546213o_d_s_
ogreish1134673ogreish
ogrism937913ogrism
oidia6314953oidi_a
oidium959813oidium
old47033463old___
olden65114853old_en
older65121173old_er
oldness836403oldness
oldwife1492253oldwife
oldy85316843old__y
oleic7313333olei_c
olein5316003olei_n
oleine6313793oleine
oleins6313523oleins
oleos55419683oleos_
oles46453473ol_es_
olio46829673ol_i_o
olios54520853ol_ios
olive84817153ol_ive
ollas54218283ollas_
ologist8313833ologist
onrush935343onrush
oolith93813243oolith
ordos65216203ordos_
orisha936773o_risha
ornis54616773ornis_
orris54516553orris_
ouds56430103oud_s_
outfish132210573outfish
outwish13289853outwish
oxidise1545043oxidise
oxids13128963oxids_
padis86227143padis_
palish114718273palish
parish115022353parish
perish114619063perish
pish96127913__pish
planish12412053planish
plash104616563pl_ash
plenish1239943plenish
plush105614713pl_ush
poleis86018353poleis_
polis74731163pol_is_
pollist9816603pollist
poloist91016323poloist
poorish123712303poorish
popish133812113popish
prudish1376563prudish
punish111411503punish
qadis155917853qadis_
rakish134313963rakish
ravish123414033ravish
rawish123012913rawish
reddish1238033reddish
redfish1437793redfish
relish93916953relish
roguish1156833roguish
rompish1436693rompish
roundish1246253roundish
rowdyish1852663rowdyish
sadis64930853sadis_
sadism94113493sadism
sadist74221353sadist
saltish10312163saltish
selfish1388513selfish
slash84719683sl_ash
slavish1338233slavish
sleigh10258203sleigh
slosh84514483sl_osh
slowish1337633slowish
slush85316573sl_ush
softish13127813softish
soldi65717203soldi__
soldier82812153soldier
solids74116403solids_
soloist7915893soloist
sottish10129443sottish
sourish10310693sourish
squish1838573squish
swish115114823_swish
tallish103313583tallish
toadfish1544903toadfish
toadyish1544153toadyish
tonish93415903tonish
tonnish10149093tonnish
townish13167933townish
toyish122911123toyish
tundish1137283tundish
unwish1239093unwish
uppish1336633uppish
vanish121513223vanish
voguish1465203voguish
wadis95223963wadis_
whish144512923_whish
winish124212263winish
wish107228733__wish
woggish15276673woggish
wolds95420183wold_s_
wolffish2043333wolffish
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.376475242.0
2DLD Change Limit1127163024.84323274.0
3Display Results3023020.0933247.3
 (SQL Overall)1786913025.31233639.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.