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

374 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
jocose153710(None) 
cocos95624692cocos_
comose105016842comose
fucose11167682fucose
goose65925902go_ose
jockos19527562jockos_
jocks185118082jocks_
jocosely2042762jocosely
jucos144111712jucos_
locoes85516582locoes
locos75822602locos_
loose56627682lo_ose
moose76327192mo_ose
morose85116242morose
mucose10149312mucose
nodose738882nodose
noose55624062no_ose
pocosen1146832pocosen
porose84818742porose
roose56127092ro_ose
torose64317692torose
accost101112263accost
accuse103411033accuse
alcove1178083alcove
aldose7311093aldose
ancone83916953ancone
apocope1346033apocope
appose10411993appose
ariose64818723ariose
arkose104911343arkose
arose55832083_arose
become123312593become
bocce114313113boc_ce
bocces123912023bocces
boccie123311443boccie
boche124216953boc_he
boches134618523boches
bocks134526573bocks_
bohos105618253bohos_
bolos75531373bolos_
boos67955033bo_os_
boost75132473bo_ost
booze164718913bo_oze
bourse84414333bourse
bouse75931853bo_use
bowse105420633bo_wse
boyos105418283boyos_
bozos165216863bozos_
brose75227033_brose
case65848083__case
choose115116143choose
chose105925403_chose
close76425223_close
coarse84813893coarse
cocas95926573cocas_
cockle143913573cockle
cocks135227163cocks_
coco87330603coco__
cocoa98517883coco_a
cocoas104915743cocoas
cocoon10312263cocoon
cocotte1138603cocotte
code77347733__code
cohos105921853cohos_
cohosh14517123cohosh
cohost115217213cohost
coke107038383__coke
cole66956113__cole
colone85425003colone
come87547703__come
compose135716663compose
concise11314463concise
cone67256963__cone
cooee74531023co_oee
coos67456493co_os_
cope86847383__cope
copse95623923co_pse
core67263113__core
corpse104013403corpse
corse75036183co_rse
cos510270393__cos_
cosec96320183__cosec
coses76949493__coses
coset75748843__coset
cosey106226713__cosey
cosh96127623__cosh
cosie74728263__cosie
coss66143493__coss
cost68057943__cost
cosy97232703__cosy
cote66648733__cote
course85117773course
cove95837073__cove
coyote11411783coyote
cymose13429653cymose
decode104414743decode
decos85522123decos_
depose94215763depose
diocese1036853diocese
docile94213123docile
docks126022313docks_
docs75631153doc_s_
dodoes85716103dodoes
dodos75819393dodos_
dojos135111793dojos_
dose56442433__dose
douse66329723do_use
dowse96020813do_wse
encase83714363encase
enclose999993enclose
encode9310443encode
encore8314773encore
eocene8311613eocene
erose55727273_erose
excise1538553excise
excuse1537423excuse
expose1549523expose
ficoes114613463ficoes
filose96112503filose
floccose1543123floccose
focus105815883focus_
focused13166413focused
focuser12155783focuser
focuses12159653focuses
foliose10378013foliose
fosse86119463fo_sse
fucoses12148303fucoses
globose1035543globose
glucose1045113glucose
goboes95914443goboes
gobos86219373gobos_
gogos77516523gogos_
golosh1036463golosh
goloshe1134723goloshe
goos57644913go_os_
goosed86817033go_osed
gooses75723053go_oses
goosey105913513go_osey
goosy96018883go_osy
gorse65926813go_rse
gyrose105310253gyrose
hexose16267843hexose
hoarse94411323hoarse
hoboes114717443hoboes
hobos106321353hobos_
hocks144925493hocks_
hocus104715203hocus_
hocused13167013hocused
hocuses121710423hocuses
hognose11117243hognose
hoise85224773ho_ise
homos105921783homos_
homosex1936123homosex
horse86132653ho_rse
hose76547243__hose
house89131423ho_use
impose103113043impose
incase83615283incase
incise83515323incise
inclose9910223inclose
income10712093income
incuse83513573incuse
iodise74214933iodise
ionise63516933ionise
ionone6313443ionone
isodose845373isodose
jacks185219833jacks_
jaconet16311483jaconet
jatos125116823jatos_
jesse126012833j_esse
jobs136529433jo_bs_
jock176522643joc__k
jockey22408033jockey
jocko184210453joc_ko
jocosity2044343jocosity
jocund1633623jocund
joe106642353j__o_e
joes116635893jo_es_
joeys15518043joeys_
joggle154010353joggle
jogs127129333jo_gs_
johns15398713johns_
joins125818413joins_
joist125125653jo_ist
jojoba1441553jojoba
joke155926163j__oke
jokes165423333jokes_
jole117233823j__ole
joles125230833joles_
jolts125018883jolts_
jomon14610083jomo_n
jones125028183jones_
jonesed1536263jonesed
joneses1438963joneses
josh145117613j__osh
joshes165114853joshes
joss115925593j__oss
josses135117683jo_sses
jostle13319863jostle
jotas125717443jotas_
jots116336143jo_ts_
jouks165612343jouks_
joule124918203jo_ule
joules134116823joules
jounce153310733jounce
joust125122293jo_ust
jowls156214523jowls_
jows146632093jo_ws_
joyous16276753joyous
joyrode1853303joyrode
joys146624663jo_ys_
juco134716203juco__
judos134711733judos_
juncoes16338073juncoes
juncos15449233juncos_
ketose105711813ketose
kobos115616893kobos_
kolos94921213kolos_
kotos95717693kotos_
lactose969473lactose
lanose6313593lanose
lobos75921843lobos_
locale83915653locale
locate83919843locate
lochs106715513lochs_
locks115126923locks_
lockset13311163lockset
loco67030743loco__
locoed94312193locoed
locoism1156793locoism
locule83412033locule
locus74819993locus_
locust85312343locust
logos67225333logos_
looie55624243lo_oie
loos49051123lo_os_
loosed75520893lo_osed
loosen66615963lo_osen
looser65219943lo_oser
looses67328243lo_oses
lose45144583__lose
lotos54724633lotos_
lotoses73713643lotoses
louse56131013lo_use
lowse87219903lo_wse
mocks135023823mocks_
mocs85834903moc_s_
mojoes15399523mojoes
mojos145314463mojos_
monos75930863monos_
moos66051303mo_os_
mopoke1436633mopoke
morse76032703mo_rse
mouse77133003mo_use
mousse84813033mousse
mozos165516333mozos_
mucosa10166273mucosa
mucosae11155313mucosae
mycoses1437723mycoses
narcose95910383narcose
necrose939723necrose
nicoise937923nicoise
nocks115121013nocks_
noise55723733no_ise
nolos54423353nolos_
nomos75919743nomos_
noncore9411953noncore
nonuse63212253nonuse
noosed75018013no_osed
nooser65517823no_oser
nooses65623643no_oses
nose46739363__nose
nowise9511073nowise
obese75212423_obese
oboe66822943_obo_e
oboes75717713_oboes
obole75917143_obole
ocas66729633_ocas_
ochone11311293_ochone
ochre103411593_ochre
onos46229003_onos_
oocyst1136133oocyst
oocyte1135753oocyte
ooze136420603_o_oze
oppose1039193oppose
ose38147343___ose
osmose8108003osmose
otiose639403otiose
owse76321623_o_wse
ozone14310613_ozone
pilose84514233pilose
pocks135022963pocks_
poco86826153poco__
pocosens1255253pocosens
pocosin1169643pocosin
pocoson1156753pocoson
poise75127893po_ise
polos76129903polos_
pomos95321573pomos_
poos65949113po_os_
poove104514303po_ove
pose66441733__pose
posole8314223posole
posse74722273po_sse
pozole1758913pozole
propose112714843propose
prose75835123_prose
ramose8314403ramose
rechose121312043rechose
recode93618713recode
recuse85519163recuse
repose84121413repose
rerose63320843rerose
ribose839893ribose
rimose8310593rimose
rockrose1444953rockrose
rocks114626413rocks_
rococo1036813rococo
rocs65533663roc_s_
roosed75621593ro_osed
rooser63921883ro_oser
rooses65526233ro_oses
roost55730933ro_ost
roscoe839763rosco_e
roscoes9310923roscoes
rose46148903__rose
rotos56027883rotos_
rouse56634703ro_use
rugose737283rugose
scone74621833_scone
scope94821483_scope
score75526733_score
scouse84113633scouse
setose65114773setose
socage91012123socage
socas74026183socas_
socks114926083socks_
socle7419573soc_le
socles8418453socles
solos54830793solos_
sorbose938983sorbose
soroses73117483soroses
souse56530773so_use
sucrose939303sucrose
sycoses1249133sycoses
tacos77023553tacos_
talcose938133talcose
those85218143_those
topos75726393topos_
toros54336193toros_
torse55833333to_rse
touse55430673to_use
toyos87519143toyos_
triose64715383triose
uncase83817433uncase
unclose91111643unclose
uncos74117033uncos_
uprose82311483uprose
vadose1037963vadose
vamose1159283vamose
venose9310843venose
viscose1237863viscose
voces105918053voces_
vocoder1334693vocoder
volost9412643volost
whose114914533_whose
woos76238803wo_os_
woosh113710733wo_osh
worse86525263wo_rse
xylose1636763xylose
yocks144418373yocks_
youse85322233yo_use
zoos135828803zo_os_
zygose19455553zygose

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.1401276364.3
2DLD Change Limit1127163745.94018975.8
3Display Results3743740.1233040.7
 (SQL Overall)1786913746.20328807.2
 
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.