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

421 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
gunnen733871(None) 
gunmen9348721gunmen
gunned83513091gunned
gunnel73411051gunnel
gunner73813981gunner
cunner83915002cunner
dunned85015522dunned
dunner73913822dunner
funned103613952funned
funnel93610742funnel
funner93414102funner
gannet74321852gannet
ginned83813982ginned
ginner73915822ginner
guanin7610802guanin
guenon736402guenon
guinea737612guinea
gulden8328762gulden
gunman9299452gunman
gunnels8358562gunnels
gunners83111722gunners
gunnery11376372gunnery
gunnies83413122gunnies
gunning93413172gunning
gunny94413662gunn_y
gunsel7339852gunsel
gurnet74920872gurnet
gurney10429412gurney
punned93416192punned
punner84918152punner
punnet83518842punnet
runnel63510662runnel
runner63814462runner
sunken103511782sunken
sunned74216322sunned
tunned74014492tunned
tunnel64310632tunnel
unpen72913572_unpen
aginner844663aginner
annex12310883_annex
banned94721343banned
banner84421503banner
bannet84925333bannet
benne76521123benne_
bennes86019013bennes
bennet84823363bennet
binned94414543binned
bonne75124713bonne_
bonnes85621453bonnes
bonnet85524633bonnet
bounden10389453bounden
bunged105218793bunged
bungee96319773bungee
bunion83111313bunion
bunked135118373bunked
bunker124519373bunker
bunn65023653bu_n_n
bunnies94415003bunnies
bunns74718293bunn_s
bunny104715803bunn_y
bunted95219183bunted
bunter85020383bunter
burden9412473burden
burned95818963burned
burner83819203burner
burnet84326173burnet
busmen1039893busmen
canned95022063canned
cannel84216403cannel
canner84625983canner
cannon84514443cannon
chunnel12395303chunnel
conned95119703conned
conner84423963conner
cunners93913463cunners
cunning104214623cunning
denned84215633denned
dinned84317613dinned
dinner74217163dinner
donne65520463donne_
donned85015743donned
donnee74317063donnee
drunken12263713drunken
dudeen857173dudeen
dunce86319263dunce_
dunces95215753dunces
dune56137583du_ne_
dunes65332173du_nes
dunged95414693dunged
dungeon9134553dungeon
dunked124315283dunked
dunker113616463dunker
dunlin739723dunlin
dunness8298983dunness
dunnest83312263dunnest
dunning93514473dunning
dunted84718503dunted
durned84113173durned
eupnea835033eupnea
fanned104117473fanned
fanner94218183fanner
fennec11326913fennec
fennel9429473fennel
finned104114603finned
funded114413893funded
funder104016083funder
funked144214113funked
funker133915763funker
funnels10348173funnels
funnest102912003funnest
funnier103210163funnier
funnies104113603funnies
funning113813613funning
funny114614833funn_y
funnymen1642013funnymen
gaen57329603g__aen
gagmen103910413gagmen
gained84617463gained
gainer74117493gainer
gander84322763gander
gane55145293g_ane_
ganef96322463g_anef
ganev95513863g_anev
ganged94619193ganged
ganger83721463ganger
gannets83811443gannets
garden84215083garden
garner73917003garner
garnet73928413garnet
gasmen93111563gasmen
gaunter82910713gaunter
gen45950513g___en
gender83517933gender
gene56237223g_ene_
genes65133093g_enes
genet66038683g_enet
genie66124923genie_
genies75324943genies
genre66016803genre_
genres75515623genres
genseng933983genseng
gentes75324163gentes
germen9612313germen
gien56330023g__ien
ginger84920033ginger
ginners84314223ginners
ginnier8298983ginnier
ginning93313983ginning
ginny95314573ginn_y
ginseng933433ginseng
girned84010513girned
given95915283g_iven
glen56027203g__len
gluten74210753gluten
gnawn9517783g_nawn
golden84411153golden
gone55639043g_one_
gonef95221293g_onef
goner66025163g_oner
gonged97115913gonged
gonion73612833gonion
gooney106612313gooney
gorhen1038893gorhen
gotten73410113gotten
gowned114410133gowned
graben9419723graben
graven104513523graven
green65522143g_reen
grinned9378553grinned
grinner8329233grinner
grunge8359583grunge_
grunger9389783grunger
grunges93310403grunges
grunion835433grunion
grunted9339283grunted
grunter83110783grunter
grutten885283grutten
guan55325583gu__an
guanay1037913guanay
guanine8810543guanine
guanines989773guanines
guanins8810013guanins
guano69213983guan_o
guanos73811993guanos
guans64419443guan_s
gude65423333gu_de_
gudes74520813gu_des
gudgeon10123743gudgeon
guenons836563guenons
guglet84018223guglet
guide75019883guide_
guided94014113guided
guider84313523guider
guides84118283guides
guidon837373guidon
guile64521133guile_
guiled84315383guiled
guiles73919283guiles
guineas836743guineas
guise64717713guise_
guised84612173guised
guises74216313guises
guldens9356573guldens
gules64831043gu_les
gulfed114810013gulfed
gulled84521373gulled
gullet74924833gullet
gulley104213163gulley
gulped104610373gulped
gulper93410213gulper
gummed123811663gummed
gummer114615453gummer
gun47240803gu___n
gundog935793gundog
gunite7414403gunite
gunites8313123gunites
gunk95423573gu_n_k
gunkier12369553gunkier
gunks104517723gu_nks
gunky135514113gu_nky
gunless8299633gunless
gunnings10346733gunnings
guns55533483gu_n_s
gunsels8338133gunsels
gurge75419783gurge_
gurged95513363gurged
gurges84716863gurges
gurnets84010793gurnets
gurneys11406463gurneys
gushed114816243gushed
gusher104115773gusher
gushes104719033gushes
gusset7316433gusset
gusted84316723gusted
gutted84716363gutted
gutter73817703gutter
guyed1049893gu_yed
gwine95513663gwine_
hunger104015203hunger
hunker133917673hunker
hunkey164210883hunkey
hunted104417013hunted
hunter94817773hunter
inned64118423_inned
inner54920633_inner
jennet134714953jennet
jinnee13411573jinnee
junked184311693junked
junker174213653junker
junket173815023junket
junkmen2033633junkmen
kenned114411263kenned
kennel10369213kennel
kronen10348913kronen
kuchen1536653kuchen
kune85424573ku_ne_
lanner64920603lanner
lenten6312883lenten
linden7411453linden
linen55728723_linen
linnet6419423linnet
lumen75220903lu_men
lumpen104010663lumpen
lune47140493lu_ne_
lunes55337773lu_nes
lunet56835423lu_net
lungan74710213lungan
lunge65323803lunge_
lunged85418273lunged
lungee75119813lungee
lunger75720423lunger
lunges76123423lunges
lunier64617603lunier
lunies64723013lunies
lunker104718343lunker
lunted74517523lunted
mannan85413623mannan
manned94418643manned
manner84020513manner
mudhen1236883mudhen
mullen83714763mullen
munnion935863munnion
muntin82915183muntin
nonmen8412833nonmen
numen74216793nu_men
nunnery10355303nunnery
ounce77019933ounce_
ounces83617773ounces
pangen94115913pangen
panne76623653panne_
panned94123433panned
panner84224763panner
pannes85522853pannes
penmen10311493penmen
penne75423853penne_
penned94217613penned
penner84616663penner
pennon8310643pennon
pinken124513283pinken
pinned94818383pinned
pinner84521503pinner
pungent10311233pungent
punier84519223punier
punker123718823punker
punkey154011173punkey
punkin123611523punkin
punners94114233punners
punnets9409263punnets
punnier93511263punnier
punning103414993punning
punny104217713punn_y
punted94618713punted
punter84320023punter
queen144312063qu_een
quinin152811953quinin
rennet64624853rennet
rennin63914033rennin
ronnel63310883ronnel
ruined74813323ruined
ruiner64013643ruiner
rumen74419503ru_men
rune45236293ru_ne_
runes55530223ru_nes
runlet63821413runlet
runnels7329153runnels
runners74212453runners
runnier74010113runnier
running83514593running
runny84613483runn_y
scunner9358243scunner
sennet64224143sennet
shunned11417843shunned
shunner10358643shunner
sinned73818413sinned
sinner64320603sinner
sonnet65923503sonnet
stunned8358893stunned
stunner7349193stunner
subnet82520933subnet
sudden83310833sudden
sullen62914293sullen
sunder74019823sunder
sundew10369693sundew
sunket103721363sunket
sunn45423593su_n_n
sunna55016063sunn_a
sunnah9369353sunnah
sunnas63914563sunnas
sunnier73412153sunnier
sunning83715673sunning
sunns55017353sunn_s
sunny84917743sunn_y
sunset63723633sunset
suntan62613003suntan
tanned75219953tanned
tanner63722283tanner
tannin62613923tannin
tenner64117103tenner
tinmen82310393tinmen
tinned74317533tinned
tinner64119963tinner
tonne54921433tonne_
tonner64819203tonner
tonnes65320853tonnes
trunnel745403trunnel
tune45635863tu_ne_
tuned64622313tu_ned
tuner56022683tu_ner
tunes55332193tu_nes
tunnels7328723tunnels
tunnies73614263tunnies
tunning83514453tunning
tunny86515033tunn_y
tureen63312723tureen
turned73914473turned
turner63914613turner
turnon638193turnon
unban72114333_unban
unbe65319273_unbe_
unbend9269773_unbend
unbent83216593_unbent
unde55825483_unde_
undee65327273_undee
under64624213_under
uneven957913_uneven
unfed94614223_unfed
unhewn12285253_unhewn
union54519793_union
unkend11309223_unkend
unkent103116053_unkent
unled64021073_unled
unlet54133333_unlet
unman72715423_unman
unmet74426393_unmet
unmew103610073_unmew
unopen838913_unopen
unpeg8309363_unpeg
unpens82511013_unpens
unpent83117373_unpent
unpin72613243_unpin
unrent63219783_unrent
unseen62012623_unseen
unsent63820963_unsent
unset54532433_unset
unsew83912693_unsew
unsewn9298393_unsewn
unsex123512633_unsex
unwed94114873_unwed
unwet84423173_unwet
unwon84512343_unwon
usnea539393_usnea
vanmen1138403vanmen
vanned104614483vanned
vanner94215843vanner
wanned104318013wanned
wanner94019623wanner
winned104017013winned
winner94219933winner
wonned104012063wonned
wonner95114443wonner
yenned10409383yenned

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 Limit1127164215.78019501.0
3Display Results4214210.1233422.8
 (SQL Overall)1786914216.04629555.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.