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

157 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
jocund163362(None) 
bound84819582bo_und
fecund1235432fecund
found94917842fo_und
hound95016482ho_und
jocundly2142212jocundly
mound83918312mo_und
pound84417862po_und
rotund737292rotund
round64318432ro_und
secund937102secund
sound64420022so_und
wound94414212wo_und
abound9239863abound
around72712413around
ascend9429733ascend
bohunk1533743bohunk
bond75334363bo__nd
bosun75113593bosun_
bosuns8439383bosuns
bounds94415803bo_unds
bund75530663__bund
coccid102910743coccid
cocked155022563cocked
cofound1335513cofound
cohune1189423cohune
could86517713co_uld
count74932053co_unt
cud67937453__cu_d
cued76329563__cued
cunt66243673__cunt
curd77634983__curd
defund11447983defund
docent92918683docent
docked145018333docked
eocene8311613eocene
focus105815883focu_s
focused13166413focused
fond86330953fo__nd
founds104814193fo_unds
fount84727033fo_unt
fund85624983__fund
gerund836163gerund
gourd71011903go_urd
ground82310273ground
hocked165521303hocked
hocus104715203hocu_s
hocused13167013hocused
hounds104413133ho_unds
iracund1042633iracund
jacana1537933jacana
jacked204817523jacked
jaunt125025273j_aunt
jejuna1243243jejuna
jejune1233763jejune
jobbed184212133jobbed
jock176522643joc__k
jockey22408033jockey
jocko184210453joc_ko
jockos19527563jockos
jocks185118083joc_ks
jocose1537103jocose
jocular1637303jocular
jocundity2252113jocundity
jogged166015923jogged
john145512903jo_hn_
johnny1932193johnny
johns15398713jo_hns
join116724833jo_in_
joined144613073joined
joins125818413jo_ins
joint125227723jo_int
joked175217913jo_ked
joking184113023joking
jolted143510633jolted
jomon14610083jomon_
jorum145513743joru_m
jorums15408093jorums
joshed174610903joshed
jotted143615173jotted
joual12311653jo_ual
jouk156015993jo_u_k
jouked18568153jouked
jouks165612343jo_uks
joule124918203jo_ule
jounce153310733jo_unce
jounced17337613jo_unced
jouncy18336203jo_uncy
journo13135293journo
joust125122293jo_ust
jowed164724423jo_wed
jowing174216043jowing
jowled174210803jowled
joyed164811833jo_yed
joying173810803joying
jun105932063j__un_
junk155121033j__unk
korun9411923korun_
koruna1035483koruna
koruny1334443koruny
lacuna8118123lacuna
lacune8169673lacune
locked134921663locked
locoed94312193locoed
locule83412033locule
loculed10317653loculed
loculi8288253loculi
locum94812173locu_m
locums10478303locums
locus74819993locu_s
locust85312343locust
loud55228043lo_u_d
maund85515453_maund
mocked154716613mocked
mould86015753mo_uld
mounds93915133mo_unds
mount74128063mo_unt
nocent83217413nocent
nocked134617383nocked
noctuid1064383noctuid
noun45724183no_un_
nouns56717313no_uns
obtund945583obtund
octad81510653_octad
oculi72010793_oculi
orotund844063orotund
osmund933803osmund
oud47439073_o_u_d
pocked154818983pocked
poind84217913po_ind
pond75530493po__nd
pounds93714383po_unds
refund104810303refund
roband92310723roband
rocked135022323rocked
rogued84711473rogued
rotunda843943rotunda
rounds73615623ro_unds
scend85516293_scend
scud76221283_scu_d
second9411153second
socked134721503socked
soland75115043soland
sounds74616183so_unds
stound7399903stound
swound10377633swound
toluid738213toluid
vicuna11115903vicuna
vodun937223vodun_
voduns1035053voduns
vogued11457633vogued
would95513153wo_uld
wounds103811633wo_unds
yocked164114423yocked
yond86122313yo__nd
young977743yo_ung
zounds164310173zo_unds

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 Limit1127161574.84323274.0
3Display Results1571570.0463413.0
 (SQL Overall)1786911575.26533939.4
 
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.