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 “hung” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

208 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
hung8612635(None) 
bung75730631bung
dung66328431dung
hang85535541hang
hong85833951hong
hug76037361hu_g
hun65844711hun_
hunh106323731hunh
hunk116029541hunk
huns76136931huns
hunt76445491hunt
lung55732491lung
pung75429631pung
rung56429971rung
sung55832171sung
tung55328161tung
ahing98928342ahing
aunt46553652aunt
bang74836992bang
bhang115512922bhang
bong75633412bong
brung84613912brung
bug65340742bu_g
bun56348142bun_
buna64730722buna
bund75530662bund
bungs85323862bungs
bunk105731352bunk
bunn65023652bunn
buns66243722buns
bunt65850852bunt
burg74930362burg
chang115418562chang
chug105914112chu_g
chunk144812382chunk
clung86013602clung
cuing85420192cuing
cunt66243672cunt
dang65131532dang
ding66940952ding
dong66031652dong
dug58138692du_g
dun46545582dun_
dune56137582dune
dungs75821972dungs
dungy104713642dungy
dunk96228572dunk
duns55140432duns
dunt55746872dunt
eng46726782_eng
fang85432542fang
flung95114582flung
fug76234512fu_g
fun66841142fun_
fund85624982fund
fungi95014132fungi
fungo94413132fungo
funk115825622funk
funs75235732funs
gang66031962gang
gong66827192gong
gun47240802gun_
gunk95423572gunk
guns55533482guns
hag77255742h_ag
hand86833702hand
hangs95726722hangs
hank115134132hank
hant75461582hant
haunt85229132haunt
hen67555272hen_
henge94819822henge
hens75642572hens
hent76656382hent
hin67559562hin_
hind85529752hind
hinge95323442hinge
hins76447992hins
hint77455742hint
hog78049062h_og
hogg96617532hogg
hon67759382hon_
hone77549322hone
hongi96715852hongi
hongs95126202hongs
honk116931192honk
hons77350782hons
hound95016482hound
hub86437482hu_b
hubs96027142hubs
huck135927632huck
hue66642302hu_e
hued86925852hued
hues75235232hues
huff135623842huff
huge86321652huge
hugs86129752hugs
huh96432012hu_h
huic94818052huic
hula74923752hula
hulk115321612hulk
hull75428782hull
hum85542932hu_m
hump116228722hump
hums96831422hums
hunch136416212hunch
hunger104015202hunger
hungry1334972hungry
hunks125321452hunks
hunky155417732hunky
hunts86826172hunts
hup86437812hu_p
hurl76029932hurl
hurt77142572hurt
hush105224112hush
husk116021952husk
hut66457292hu_t
huts76737442huts
hying126514742hying
jug115529542ju_g
jun105932062jun_
junk155121032junk
king95933652king
kuna85120702kuna
kune85424572kune
lang56637372lang
ling57447962ling
long56933342long
lug46138062lu_g
luna46229852luna
lune47140492lune
lunge65323802lunge
lungi65516052lungi
lungs65223882lungs
lunk86030722lunk
lunt46148842lunt
luny77324132luny
mug65837692mu_g
mugg86316012mugg
mun56143852mun_
mungo84916052mungo
muni65824402muni
muns65535912muns
nun35537742nun_
nuns45228232nuns
ohing96018802ohing
pang75336282pang
ping75943592ping
pong76231142pong
pug65337182pu_g
pun58846512pun_
puna65331652puna
pungs85422222pungs
punk105729972punk
puns66641482puns
punt65747202punt
puny95526992puny
quag144815942quag
rang56939152rang
rehung1036342rehung
ring56541152ring
rug46039152ru_g
ruing67221052ruing
run36244982run_
rune45236292rune
rungs611819402rungs
runs46438072runs
runt46647982runt
sang55441222sang
shun75122772shun_
shuns85018142shuns
shunt85226502shunt
sing57544172sing
slung65117832slung
snug55218692snug
song55133672song
stung65417152stung
suing65026362suing
sun37149032sun_
sunk85031812sunk
sunn45423592sunn
suns45841902suns
swung95610562swung
tang56138662tang
thing96622962thing
thong95014172thong
thug86415482thu_g
thunk124911852thunk
ting56139892ting
tong56434352tong
tug45937402tu_g
tun35845192tun_
tuna45127842tuna
tune45635862tune
tungs65520622tungs
tuns45138662tuns
un28341132_un_
unhung1035282unhung
uns35936752_uns
vang84926032vang
vug76127412vu_g
vugg95612712vugg
whang124813382whang
wing86339222wing
wrung9549802wrung
yang85626062yang
young977742young
zing145728612zing

Search took 1 second 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 Filter178691298720.0762351197.4
2DLD Change Limit298722080.73640587.0
3Display Results2082080.0464521.7
 (SQL Overall)1786912080.858208264.6
 
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.