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

505 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
tunnel6431063(None) 
funnel93610741funnel
gunnel73411051gunnel
runnel63510661runnel
trunnel745401trunnel
tunned74014491tunned
tunnels7328721tunnels
cannel84216402cannel
chunnel12395302chunnel
cunner83915002cunner
dunned85015522dunned
dunner73913822dunner
fennel9429472fennel
funned103613952funned
funnels10348172funnels
funner93414102funner
gunned83513092gunned
gunnels8358562gunnels
gunnen7338712gunnen
gunner73813982gunner
gunsel7339852gunsel
kennel10369212kennel
punned93416192punned
punner84918152punner
punnet83518842punnet
ronnel63310882ronnel
runnels7329152runnels
runner63814462runner
stunned8358892stunned
stunner7349192stunner
sunned74216322sunned
tanned75219952tanned
tanner63722282tanner
tenner64117102tenner
tinned74317532tinned
tinner64119952tinner
tinsel639442tinsel
tonne54921432tonne_
tonner64819202tonner
tonnes65320852tonnes
trunnels844512trunnels
tune45635862tu_ne_
tuned64622312tu_ned
tuner56022682tu_ner
tunes55332192tu_nes
tunneled955232tunneled
tunneler864472tunneler
tunnies73614262tunnies
tunny86515032tunn_y
turned73914472turned
turner63914612turner
angel65019563_angel
annal56520763_annal
anneal64812293_anneal
annex12310883_annex
annul55813383_annul
banned94721343banned
banner84421503banner
bannet84925333bannet
benne76521123benne_
bennes86019013bennes
bennet84823363bennet
binned94414543binned
bonne75124713bonne_
bonnes85621453bonnes
bonnet85524633bonnet
bulbel104510683bulbel
bundle94315573bundle
bunged105218793bunged
bungee96319773bungee
bungle97116113bungle
bunked135118373bunked
bunker124519373bunker
bunn65023653bunn__
bunnies94415003bunnies
bunns74718293bunn_s
bunny104715803bunn_y
bunted95219183bunted
bunter85020383bunter
burned95818963burned
burner83819203burner
burnet84326173burnet
bushel114513943bushel
cancel105316683cancel
canned95022063canned
cannels93413363cannels
canner84625983canner
channel123910483channel
chunnels13304553chunnels
conned95119703conned
conner84423963conner
cornel84020053cornel
counsel948543counsel
crenel84213063crenel
cudgel1036693cudgel
cuneal8611513cuneal
cunners93913463cunners
cupel9514303cu_pel
darnel74312183darnel
denned84215633denned
dinned84317613dinned
dinner74217153dinner
donne65520463donne_
donned85015743donned
donnee74317063donnee
donzel1636313donzel
duel56729703du__el
duffel13407753duffel
dunce86319263dunce_
dunces95215753dunces
dune56137583du_ne_
dunes65332173du_nes
dunged95414693dunged
dunked124315283dunked
dunker113616463dunker
dunness8298983dunness
dunnest83312263dunnest
dunted84718503dunted
durned84113173durned
dynel9569853_dynel
eupnea835033eupnea
fanned104117473fanned
fanner94218183fanner
fennec11326913fennec
fennels10387903fennels
finned104114603finned
flannel1035423flannel
fuel76824733fu__el
funded114413893funded
funder104016083funder
fungal10388733fungal
funked144214113funked
funker133915763funker
funneled1254873funneled
funnest102912003funnest
funnier103210163funnier
funnies104113603funnies
funnily1336373funnily
funny114614833funn_y
fusel85218493fu_sel
gannet74321853gannet
ginned83813983ginned
ginner73915813ginner
guinea737613guinea
gunmen9348723gunmen
gunners83111723gunners
gunnery11376363gunnery
gunnies83413123gunnies
gunny94413663gunn_y
gunsels8338133gunsels
gurnet74920873gurnet
gurney10429413gurney
hansel95214373hansel
hunger104015203hunger
hunker133917673hunker
hunkey164210883hunkey
hunted104417013hunted
hunter94817773hunter
inned64118423_inned
inner54920623_inner
jennet134714953jennet
jinnee13411573jinnee
jungle144012653jungle
junked184311693junked
junker174213653junker
junket173815023junket
jurel124516333ju_rel
kenned114411263kenned
kennels11387193kennels
kernel104010583kernel
kneel95012033_kneel
kugel1068563ku_gel
kummel14266173kummel
kune85424573ku_ne_
lanner64920593lanner
linnet6419413linnet
lintel64013993lintel
lune47140493lu_ne_
lunes55337773lu_nes
lunet56835423lu_net
lunge65323803lunge_
lunged85418273lunged
lungee75119813lungee
lunger75720413lunger
lunges76123423lunges
lunier64617603lunier
lunies64723013lunies
lunker104718343lunker
lunted74517523lunted
lunule638433lunule
mangel94017533mangel
manned94418643manned
manner84020513manner
mantel84317973mantel
mussel83412903mussel
mutuel837823mutuel
noel45226553__noel
nuncle839363nuncle
nunnery10355293nunnery
ounce77019933ounce_
ounces83617773ounces
ousel55222403ou_sel
ouzel144612323ou_zel
panel76023623_panel
panne76623653panne_
panned94123433panned
panner84224763panner
pannes85522853pannes
pencel103812913pencel
penne75423853penne_
penned94217613penned
penner84616663penner
pinnal84814273pinnal
pinned94818383pinned
pinner84521493pinner
pummel12278043pummel
pungle94413573pungle
punier84519223punier
punker123718823punker
punkey154011173punkey
punners94114233punners
punnets9409263punnets
punnier93511263punnier
punny104217713punn_y
punted94618713punted
punter84320023punter
quinela1635203quinela
quinol15357973quinol
rennet64624853rennet
rondel73212643rondel
ronnels7318613ronnels
roundel8308853roundel
rubel75416833ru_bel
ruined74813323ruined
ruiner64013643ruiner
rundle73214233rundle
rune45236293ru_ne_
runes55530223ru_nes
runkle103611543runkle
runlet63821413runlet
runners74212453runners
runnier74010113runnier
runny84613483runn_y
scunner9358243scunner
sennet64224143sennet
shunned11417843shunned
shunner10358643shunner
simnel857023simnel
sinned73818413sinned
sinner64320593sinner
sonnet65923503sonnet
spinel85317333spinel
stunners8277923stunners
stunted83010403stunted
subnet82520933subnet
sunbelt939233sunbelt
sunder74019823sunder
sundew10369693sundew
sunken103511783sunken
sunket103721363sunket
sunn45423593sunn__
sunna55016063sunn_a
sunnah9369353sunnah
sunnas63914563sunnas
sunnier73412153sunnier
sunnily1037833sunnily
sunns55017353sunn_s
sunny84917743sunn_y
sunset63723633sunset
tael46030713t__ael
tandem9311403tandem
tanged84622493tanged
tangelo837033tangelo
tangle74019953tangle
tanked113919293tanked
tanker104521123tanker
tanners74018393tanners
tannery10388653tannery
tannest72617853tannest
tannic82811473tannic
tannin62613923tannin
tannoy958353tannoy
tanrec837803tanrec
tarnal63716503tarnal
tassel66014773tassel
taunted84310963taunted
taunter73111453taunter
tawney12338233tawney
teasel63914983teasel
teazel15368543teazel
teel46335803t__eel
teener64717503teener
tel35647903t___el
telnet6518833telnet
tenail64516103tenail
tended83819483tended
tender74121843tender
tenet55542213t_enet
tenge65720433tenge_
tenners74014923tenners
tennies73017973tennies
tennis64015303tennis
tenoned839363tenoned
tenoner739673tenoner
tenrec837513tenrec
tense55225843tense_
tensed74817833tensed
tensely1037363tensely
tenser64919433tenser
tenses64722553tenses
tented74221003tented
tenter64623933tenter
tenues63816443tenues
tercel83612993tercel
terne56426153terne_
ternes65422903ternes
thane86122533thane_
thanes94918983thanes
thenal92712413thenal
thine85026853thine_
thinned11399153thinned
thinner10358963thinner
thunder1136963thunder
thunked15386853thunked
tincal83913353tincal
tinder73821803tinder
tine45855133t_ine_
tinea54923153t_inea
tineal66216153tineal
tined65434533t_ined
tines54848423t_ines
tinful938043tinful
tinge64626613tinge_
tinged84220793tinged
tinges74722323tinges
tingle74319053tingle
tinier63622233tinier
tinker103619923tinker
tinkle103714453tinkle
tinmen82310393tinmen
tinners73717303tinners
tinnier72910133tinnier
tinnily1047363tinnily
tinny85317653tinn_y
tinsels738373tinsels
tinted74419533tinted
tinter63923643tinter
tonal53724303t_onal
tone46953743t_one_
toned65435343t_oned
toner55336243t_oner
tones56048663t_ones
toney86027413t_oney
tonged86518903tonged
tonger74719683tonger
tonier65520713tonier
tonlet62924703tonlet
tonneau765913tonneau
tonners73816403tonners
tonsil6311873tonsil
tourney1036273tourney
towel84920523t_owel
townee92815213townee
tramel84113713tramel
travel94112983travel
trinal6516953trinal
trine54734603trine_
trined74920713trined
trines64132563trines
trone55131863trone_
trones65629283trones
trowel94211463trowel
trundle8307873trundle
trunked12358413trunked
tubae74716643tubae_
tubal75517203tu_bal
tubbed114712223tubbed
tubber104313203tubber
tube65828663tu_be_
tubed85818043tu_bed
tuber75420683tu_ber
tubes74826453tu_bes
tubful1136683tubful
tubule839853tubule
tucked134017493tucked
tucker124316953tucker
tucket124219483tucket
tuffet122612083tuffet
tufted10359283tufted
tufter9319933tufter
tugged93813523tugged
tugger84013103tugger
tuille63012643tuille
tule45735873tu_le_
tules54532793tu_les
tulle54019933tulle_
tulles63218893tulles
tumble103215643tumble
tumbrel11406853tumbrel
tumped114216233tumped
tun35845193tu_n__
tuna45127843tu_n_a
tunable92511313tunable
tunably12218293tunably
tunas54224123tu_nas
tundra736423tundra
tuneful1046123tuneful
tuners64417343tuners
tuneup835203tuneup
tung55328163tu_n_g
tungs65520623tu_ngs
tunic74018223tu_nic
tunica8379813tunica
tunicle9308033tunicle
tunics83811263tunics
tuning74016843tuning
tunnage8166373tunnage
tunnages9195903tunnages
tunnelers953463tunnelers
tunneling1034693tunneling
tunnelled1054583tunnelled
tunneller963893tunneller
tunning83514453tunning
tuns45138663tu_n_s
tupelo836483tu_pelo
tupped114013233tupped
tuque14469193tuque_
tuques15358373tuques
tureen63312723tureen
turfed103110963turfed
turkey1337763turkey
turn46330383turn__
turners73912893turners
turnery10357423turnery
turnip836593turnip
turnkey1433013turnkey
turnon638193turnon
turns55623233turn_s
turnup835093turnup
turret63121853turret
turtle63213573turtle
turves94212693turves
tushed104615893tushed
tushes94319473tushes
tusked114112153tusked
tusker104212193tusker
tussal6288323tussal
tusseh9448423tusseh
tusser64615833tusser
tusses64921243tusses
tussle637143tussle
tutee5423523tu_tee
tutees6514553tutees
tutted75117443tutted
tutued7349413tutued
tuxes124316043tu_xes
tuyer85414293tu_yer
twine85822363twine_
twined104413123twined
twiner94012593twiner
twines94717273twines
twinned11366333twinned
tyne76325053t_yne_
tyned95915013t_yned
tynes85920303t_ynes
umbel93612833_umbel
unbe65319273_unbe_
unbelt83015693_unbelt
uncle7317053_uncle
unde55825483_unde_
undee65327273_undee
under64624213_under
unfed94614223_unfed
unfelt92413463_unfelt
unhelm1136863_unhelm
unled64021073_unled
unlet54133333_unlet
unmet74426393_unmet
unmew103610073_unmew
unnail6410583_unnail
unpeg8309363_unpeg
unpen72913573_unpen
unreal64414453_unreal
unreel63612933_unreel
unseal63315473_unseal
unsell63512543_unsell
unset54532433_unset
unsew83912693_unsew
unsex123512633_unsex
until53517743_until
unveil957343_unveil
unwed94114873_unwed
unwell9349443_unwell
unwet84423173_unwet
usnea539393_usnea
vanned104614483vanned
vanner94215843vanner
wanned104318013wanned
wanner94019623wanner
winned104017013winned
winner94219923winner
wonned104012063wonned
wonner95114443wonner
wurzel1834993wurzel
yenned10409383yenned

Search took 8 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 Limit1127165057.34315350.1
3Display Results5055050.3301530.3
 (SQL Overall)1786915057.81322871.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.