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

492 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
fungus1041818(None) 
fugus95914011fu_gus
fundus10429171fundus
fungous11367431fungous
bungs85323862bung_s
dingus83611842dingus
dungs75821972dung_s
fangas105017192fangas
fangs96224072fang_s
fondus105210942fondus
fucous11399862fucous
fucus105515892fu_cus
fudges114314492fudges
fugs85730692fu_g_s
fugu85419862fu_gu_
fugue94313372fu_gue
fugues104511682fu_gues
funds94119252fun_ds
fungal10388732fungal
fungals11276782fungals
fungi95014132fung_i
fungic12387812fungic
fungo94413132fung_o
fungoes11388812fungoes
funguses1254712funguses
funks125318912fun_ks
funs75235732fun__s
lunges76123422lunges
lungis77113022lungis
lungs65223882lung_s
mungos94311372mungos
pungs85422222pung_s
rungs611819402rung_s
tungs65520622tung_s
unaus53216572_unaus
uncus74014982_uncus
ungues7412122_ungues
unguis738442_unguis
vulgus1035782vulgus
aeneus61111143aeneus
angas65827983_angas
ankus91410683_ankus
anus47131113_an_us
argus66716543_argus
augur64311213au_gur
augurs7399963au_gurs
august739203au_gust
aunts55227633aun_ts
aureus65314883aureus
aurous64119263aurous
bangs85627773bang_s
binges93923123binges
bingos95514793bingos
blunges104212223blunges
bogus85616473_bogus
bongos95316653bongos
bongs87828423bong_s
bonus75324323bon_us
bubus95115453bu_bus
budges104820123budges
bugs76035913bu_g_s
bulges95919323bulges
bulgur9387533bulgur
bulgurs10397113bulgurs
bunas75126573bun_as
buncos104011593buncos
bunds85523543bun_ds
bundts95010843bundts
bung75730633bung__
bunged105218793bunged
bungee96319773bungee
bungees104513103bungees
bungle97116113bungle
bungles104116763bungles
bunkos124210323bunkos
bunks115125083bun_ks
bunkum1435983bunkum
bunkums1544053bunkums
bunns74718293bun_ns
buns66243723bun__s
bunts75729803bun_ts
bunyas11359433bunyas
bupkus14385683bupkus
burghs12519923burghs
burgs84924093burg_s
burnous938823burnous
cangue91012443cangue
cangues10611823cangues
cantus85117763cantus
census84310303census
congas94417033congas
conges94928173conges
congius103210073congius
congos94219883congos
congous103615073congous
conus76726533con_us
cultus85110733cultus
cundum1136513cundum
cundums1235183cundums
cunts76125123cun_ts
cuscus1038113cuscus
dangs75623203dang_s
dengue838253dengue
dengues938183dengues
dinges83825423dinges
dings76331403ding_s
dongas84914613dongas
dongs76525813dong_s
dufus94010813du_fus
dugs614832283du_g_s
dunams937833dunams
dunces95215753dunces
dunes65332173dun_es
dung66328433dung__
dunged95414693dunged
dungy104713643dung_y
dunks105621193dun_ks
duns55140433dun__s
dunts65828413dun_ts
engs56121393_eng_s
fadges114814023fadges
fags86939123f_ag_s
famous11412393famous
fanegas1145713fanegas
fanes84639893fan_es
fang85432543fang__
fanga96119623fang_a
fanged114318223fanged
fanons96115213fanons
fanos85926503fan_os
fans76247363fan__s
fanum10313443fan_um
fanums1137263fanums
faunas94013633faun_as
fauns84516753faun__s
favus114311733f_avus
feigns10407753feigns
fences114617113fences
fends96324973fen_ds
fens76139763fen__s
fetus85816543f_etus
feus75830753f__eus
fichus14388103fichus
ficus105015493f_icus
fidges114114383fidges
figs85332643f_ig_s
finals94316163finals
fincas113512063fincas
finds95424823fin_ds
fines86644263fin_es
finger104920323finger
fingers113418423fingers
finis86824253fin_is
finks125424223fin_ks
finos86226943fin_os
fins75849093fin__s
flags95321283flag_s
flanges113413273flanges
flatus94310783flatus
flings106715283fling_s
flogs95919963flog_s
flongs105010493flong_s
flung95114583flung__
flunks13469863flun_ks
flus75626543f__lus
focus105815883f_ocus
foetus958523foetus
fogs87035003f_og_s
fonds95824823fon_ds
fondu96013973fondu_
fondue104510493fondue
fondues11399313fondues
fons76943893fon__s
fonts86124753fon_ts
forges105024263forges
founds104814193foun_ds
founts94313383foun_ts
frags96322163frag_s
friges104116483friges
frigs96019273frig_s
fringes113514103fringes
frogs96220773frog_s
frugs96114283frug_s
fubs96328793fu__bs
fucks144419253fu_cks
fuckup1733963fuckup
fuckups1832923fuckups
fudge105315523fudg_e
fudged125212813fudged
fuds86528563fu__ds
fuels87117353fu_els
fug76234513fu_g__
fugal95613033fu_gal
fugged124615383fugged
fuggy135411673fu_ggy
fugio9310923fu_gio
fugios1037583fugios
fugle94915543fu_gle
fugles104715783fugles
fugued11478713fu_gued
fuguist1136073fu_guist
fujis15379243fu_jis
fulgid1137043fulgid
fulls84623523fu_lls
fulness10248963fulness
fulvous1334543fulvous
fumers113613383fumers
fumes105224703fu_mes
fumets114311813fumets
fumulus1234443fumulus
fun66841143fun___
fund85624983fun__d
funded114413893funded
funder104016083funder
funders113813933funders
fundi96814913fun_di
fundic12389083fundic
funest94316863funest
funfest13348083funfest
fungoid1245243fungoid
fungoids1343993fungoids
funhouse1444523funhouse
funk115825623fun__k
funked144214113funked
funker133915763funker
funkers143712063funkers
funkia1336343funkia
funkias1435383funkias
funky154315133fun_ky
funned103613953funned
funnel93610743funnel
funnels10348173funnels
funner93414103funner
funnest102912003funnest
funnies104113603funnies
funny114614833fun_ny
furans94515953furans
furfur1235553furfur
furies95126373furies
furious103110633furious
furls85322053fu_rls
furors9310953furors
furs76735043fu__rs
furzes186613693furzes
fuscous1256673fuscous
fusees95416403fusees
fusels94412453fusels
fuses85628423fu_ses
fusils93912343fusils
fuss76027933fu__ss
fusses94920553fusses
futons93911513futons
futzes184313113futzes
fuzees184910753fuzees
fuzes175120223fu_zes
fuzils18407963fuzils
fuzzes175412253fuzzes
fynbos1433283fynbos
gangs76222573gang_s
gangue81310573gangue
gangues9149753gangues
genius74512923genius
genus65319833gen_us
gnus56518003_gn_us
gongs74921613gong_s
grunges93310403grunges
gunks104517723gun_ks
guns55533483gun__s
gurges84716863gurges
gurus64318193gu_rus
hangs95726723hang_s
hangul1049213hangul
hangup1277293hangup
hangups1364813hangups
henges104516453henges
hinges105121023hinges
hongs95126203hong_s
hugs86129753hu_g_s
hummus1336243hummus
humus106215073hu_mus
hung86126353hung__
hunger104015203hunger
hungers114013303hungers
hungry1334973hungry
hunks125321453hun_ks
huns76136933hun__s
hunts86826173hun_ts
incus73315053_incus
judges153713453judges
jugs125525603ju_g_s
jugum15167473ju_gum
jugums16104673ju_gums
jujus11347463ju_jus
jukus16398673ju_kus
juncos15449233juncos
jungle144012653jungle
jungles154112543jungles
jungly17407693jungly
junks164815973jun_ks
juntas134210503juntas
juntos134110843juntos
kagus105812033_kagus
kanzus1944603kanzus
kings105825563king_s
kudus104910803ku_dus
kudzus20443953kudzus
kurus98015633ku_rus
langue71012173langue
langues81211913langues
langur7109303langur
langurs889103langurs
lingas75116563lingas
lings67135773ling_s
lingua7509903lingua
longes75925573longes
longs65527063long_s
lounges84811353lounges
luaus54514903lu_aus
luges65928753lu_ges
lugs55233523lu_g_s
lulus54315163lu_lus
lunars65012813lunars
lunas55025013lun_as
lunes55337773lun_es
lunets66914763lunets
lung55732493lung__
lungan74710213lungan
lungans8399053lungans
lunge65323803lung_e
lunged85418273lunged
lungee75119813lungee
lungees84412143lungees
lunger75720413lunger
lungers83817083lungers
lungful1144013lungful
lungfuls1242773lungfuls
lungi65516053lung_i
lungyi10525093lungyi
lungyis11294103lungyis
lunies64723013lunies
lunks94822453lun_ks
lunts55826903lun_ts
lupous849433lupous
lupus74512523lu_pus
lusus54813873lu_sus
magus85318753_magus
mangas94122923mangas
manges94628943manges
mangos94319333mangos
manus75924923man_us
menus75822843men_us
minus75223933min_us
mongos94318623mongos
mucous104411653mucous
mucus94015743mu_cus
muggs94912323mu_ggs
muggur10325593muggur
muggurs11315103muggurs
mugs76232043mu_g_s
mumus95517283mu_mus
mungo84916053mung_o
mungoes103510463mungoes
munis75022003mun_is
muns65535913mun__s
negus64513563_negus
nous46136983__nous
nudges84114733nudges
nuns45228233nun__s
nus37939393__n_us
onus45826813_on_us
ounces83617773ounces
outgas7313203outgas
outgun7349643outgun
outguns8318693outguns
outgush1145133outgush
pangas99921103pangas
pangs84628663pang_s
pengos94612413pengos
pignus937953pignus
pingos95317673pingos
pings85830883ping_s
plunges104011613plunges
pongs85526343pong_s
prunus8399363prun_us
pugs76332773pu_g_s
punas74826753pun_as
pung75429633pung__
pungle94413573pungle
pungles104013713pungles
punjis1536693punjis
punkas123410673punkas
punks114822683pun_ks
puns66641483pun__s
puntos85915793puntos
punts75828003pun_ts
pupus94614043pu_pus
purges94421763purges
quags154613253quag_s
quangos1734653quangos
quipus17458003quipus
ranges73826923ranges
rings65029173ring_s
rubus76415053ru_bus
ruckus12407793ruckus
rufous948263rufous
rugous739643rugous
rugs56033683ru_g_s
ruinous739753ruinous
rumpus10458893rumpus
runes55530223run_es
rung56429973rung__
runout6414873runout
runouts737343runouts
runs46438073run__s
runts55927633run_ts
sangas75222653sangas
sanghs105312063sanghs
singes74326853singes
sings65532703sing_s
sinus55523853sin_us
snugs64913023snug_s
songs67725553song_s
subgum1136133subgum
subgums1235893subgums
sughs95313323su_ghs
sulcus8410493sulcus
sulus54821883su_lus
sung55832173sung__
sunnas63914563sunnas
sunns55017353sun_ns
suns45841903sun__s
sunup7313053sun_up
sunups837263sunups
surges73924593surges
syngas10368913syngas
tangos74216303tangos
tangs65028343tang_s
tendus75111183tendus
tinges74722323tinges
tings65329193ting_s
tongas74315513tongas
tongs65928463tong_s
tongue7410093tongue
tongues879693tongues
tonus56324303ton_us
tragus749223tragus
tugs56231673tu_g_s
tunas54224123tun_as
tuners64417343tuners
tunes55332193tun_es
tuneup835203tuneup
tuneups933333tuneups
tung55328163tung__
tunics83811263tunics
tuns45138663tun__s
tutus55214813tu_tus
ughs85410973_u_ghs
ulus45622563_u_lus
unais53420773_unais
unau43924153_unau_
unbusy1135213_unbusy
uncos74117033_uncos
uncut73219173_uncut
undue66715553_undue
unglue748003_unglue
unglues836993_unglues
ungot61718063_ungot
ungual738183_ungual
ungula737603_ungula
unhusk1334263_unhusk
units54923433_units
unjust1337873_unjust
uns35936753_un__s
urges64619913_urges
urus46426133_u_rus
vagus96713813_vagus
valgus1047103valgus
vangs96319583vang_s
venges104015143venges
venous93713193venous
venus84918903ven_us
vinous93914173vinous
vuggs10579133vu_ggs
vughs12678743vu_ghs
vugs87022873vu_g_s
wangun1037103wangun
wanguns1135023wanguns
wings95727243wing_s
yangs95618693yang_s
youngs1035383young_s
yugas95012063yu_gas
zings154620893zing_s

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.1401276364.3
2DLD Change Limit1127164925.64019985.1
3Display Results4924920.1563153.8
 (SQL Overall)1786914925.93630102.9
 
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.