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

307 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
owlish123869(None) 
coolish12312522coolish
cowfish1836432cowfish
delish105215612delish
dollish11610092dollish
foolish1339612foolish
lowish12310532low_ish
mulish11311902mulish
oafish121311722oafish
oddish11107652oddish
offish15137272offish
ogrish1039262ogrish
oldish10169312oldish
oolith93813242oolith
owlishly1743592owlishly
owls76022932owl_s_
palish114718272palish
polish114916722polish
relish93916952relish
swish115114822sw_ish
townish13167932townish
whish144512922_whish
wish107228732_w_ish
wolfish1636932wolfish
ablush1147223ablush
abolish12311503abolish
aguish1059283aguish
alist56136783_alist
apish105116633_apish
aslosh966233aslosh
aspish114810333aspish
awash116613163aw_ash
aweigh1334933aweigh
awless939263awless
awls75926093awl_s_
baldish1339503baldish
banish111416043banish
bliss75616913_bliss
blowfish1944703blowfish
bluish1159243bluish
blush105115313_blush
boarish123911913boarish
boggish14238653boggish
boobish14338943boobish
bookish163610023bookish
boorish123712593boorish
bowless123310313bowless
bowlike16349473bowlike
bowline123613113bowline
bowling133916493bowling
bowls106121433bowl_s_
boxfish2285543boxfish
boyish142911233boyish
brownish1645643brownish
bullish12511193bullish
calash11312433calash
caliph13311403caliph
carlish12312763carlish
ceorlish1345383ceorlish
clash106219033_clash
clownish1643803clownish
coalfish1635493coalfish
cockish1838503cockish
codfish1637163codfish
coldish1399303coldish
coltish121310933coltish
coulis84018753coulis_
cowlick1835263cowlick
cowling134017413cowling
cowls106922213cowl_s_
coyish143710393coyish
cuish10313173_cuish
cultish12139113cultish
danish101513793danish
delis64928543delis_
delist74625053delist
dish86328333__dish
dogfish15226763dogfish
doggish13237533doggish
doltish11118733doltish
donnish11187633donnish
dovish1338103dovish
dowdyish1952833dowdyish
dryish1336323dryish
dudish1148313dudish
dullish1148743dullish
elfish1267963elfish
elvish1277563elvish
english1137953english
enlist6417043enlist
eolith93013903eolith
famish14311843famish
fetish12310373fetish
finish124613403finish
fish106926273__fish
flash115716213_flash
flesh115013743_flesh
fluish1239333fluish
flush115116073_flush
fogyish1735363fogyish
folkish1736563folkish
follis93113903follis_
foolfish1744393foolfish
foppish1735103foppish
fowling143713113fowling
fowls115518893fowl_s_
foxfish2354483foxfish
galosh1038553galosh
garish104516923garish
gawkish1835833gawkish
ghoulish1543543ghoulish
girlish1137193girlish
goatish1139563goatish
golosh1036463golosh
goodish1237963goodish
goulash1164273goulash
goyish13379013goyish
hawkish2036553hawkish
hellish13310723hellish
hogfish17257023hogfish
hoggish15247593hoggish
holism113713743holism
holist94723213holist
hottish13117893hottish
howling143413163howling
howls116219223howl_s_
impish13499193impish
iwis77117013iw_is_
jadish17319903jadish
jewfish2343543jewfish
jowlier17327563jowlier
jowliest18247623jowliest
jowls156214523jowl_s_
kaliph1537873kaliph
knish1238603_knish
lash76539653__lash
latish92416173latish
lavish124112983lavish
lich96230843__lich
lis37162273__lis_
lisp68926873__lisp
list47055343__list
loggish12258723loggish
longish11229093longish
loudish1137983loudish
loutish1039963loutish
lowlier10338903lowlier
lowliest11229473lowliest
lowlife1335143lowlife
lowlight1554943lowlight
lowlily1335353lowlily
lush75327693__lush
lweis8458693lweis_
marish114319053marish
mawkish1935823mawkish
minish115216303minish
mobbish1635923mobbish
modish123813543modish
monish114217593monish
monkish1638243monkish
moonish123311043moonish
moorish123311783moorish
mopish134311593mopish
newish1237903newish
noirish1037883noirish
nourish1039703nourish
nowise9511073now_ise
oarfish13158613oarfish
oasis56422553oasis_
obelise9310173obelise
obelisk1345193obelisk
obelism1138203obelism
obiism1036363obiism
obis66226843o_bis_
oblast8613663oblast
oblige937653oblige
oboist8312683oboist
oculist9310883oculist
odalisk1265373odalisk
odist6421913o_dist
ogles65223183ogles_
ogling83211883ogling
ogreish1134673ogreish
ogrism937913ogrism
oilier64417233oilier
oiliest72817683oiliest
oilily93111723oilily
oiling74925313oiling
oils46337973oil_s_
olds55926573o_lds_
oles46453473o_les_
olio46829673o_li_o
olios54520853o_lios
olive84817153o_live
ollas54218283ollas_
online6315843online
onrush935343onrush
oolite63319603oolite
ooliths10268323ooliths
oralism9513763oralism
oralist7619633oralist
orisha936773o_risha
orles55326213orles_
ornis54616773ornis_
orris54516553orris_
otolith10108283otolith
outfish132210573outfish
outwish13289853outwish
owes75137103ow_es_
owing96222723ow_ing
owl66228973owl___
owlet83324463owl_et
owlets93110393owlets
owllike1435713owllike
owning104110333owning
owns76819583ow_ns_
owse76321623ow__se
oxalis1339223oxalis_
oxlike17307473oxlike
oxlip1456883oxli_p
oxlips1544433oxlips
parish115022353parish
perish114619063perish
pilis75825203pilis_
pish96127913__pish
plash104616563_plash
plush105614713_plush
polis74731163polis_
pollist9816603pollist
poorish123712303poorish
popish133812113popish
publish1447913publish
pulis74225603pulis_
punish111411503punish
radish103516913radish
rakish134313963rakish
ravish123414033ravish
rawish123012913rawish
relist64628413relist
roguish1156833roguish
rompish1436693rompish
rowdyish1852663rowdyish
saltish10312163saltish
sawfish1637683sawfish
selfish1388513selfish
slash84719683_slash
slosh84514483_slosh
slowish1337633slow_ish
slush85316573_slush
softish13127813softish
sottish10129433sottish
sourish10310693sourish
splash1168823splash
splosh1186543splosh
squish1838573squish
stylish13197443stylish
swash116316753sw_ash
swinish1347203swinish
swishy15365843sw_ishy
swiss86712903sw_iss
swith115917403sw_ith
swoosh12195213swoosh
sylis84316023sylis_
tallish103313583tallish
toadish1139063toadish
tonish93415903tonish
tonnish10149093tonnish
towline102911543towline
toyish122911123toyish
twist86820983tw_ist
unlash938793unlash
unwish1239093unwish
uppish1336633uppish
valise92917643valise
vanish121513203vanish
voguish1465203voguish
vowless13246603vowless
waist86132383_waist
wash106033813_w_ash
weigh125412513_weigh
welsh113110363_welsh
which163910083_which
whisht154510813_whisht
whisk154510143_whisk
whist115322953_whist
wich125724743_w_ich
widish13419363widish
wildish1446853wildish
winish124212263winish
wis66552333_w_is_
wise75737343_w_ise
wisha114910853_w_isha
wisp97124073_w_isp
wiss75630543_w_iss
wist78049293_w_ist
with105730473_w_ith
woggish15276673woggish
wolds95420183wolds_
wolffish2043333wolffish
wolfs116214163wolfs_
woosh113710733_woosh
wormish1537163wormish
wrist84827563_wrist
yokelish1843983yokelish
yowling143610223yowling
yowls115715433yowl_s_
ywis105313103yw_is_

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.1431249587.4
2DLD Change Limit1127163076.51617298.3
3Display Results3073070.1062896.2
 (SQL Overall)1786913076.76526414.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.