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

262 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
dong6603165(None) 
bong75633411bong
dang65131531dang
ding66940951ding
dog57449751do_g
doing74923581doing
don46757651don_
dona55529631dona
done55747911done
donga76718421donga
dongs76525811dongs
dons56048701dons
dung66328431dung
gong66827191gong
hong85833951hong
long56933341long
pong76231141pong
song55133671song
tong56434351tong
along65419492along
among85813302among
bang74836992bang
bog67852412bo_g
boing84725552boing
bond75334362bond
bone65949322bone
bongo85720942bongo
bongs87828422bongs
bonk105531712bonk
bony96732082bony
bung75730632bung
cog69552902co_g
con510268022con_
cone67256962cone
conga85419872conga
conge85227592conge
congo85623132congo
coni65534802coni
conk106531442conk
conn66229132conn
cons66057692cons
cony96537832cony
dag57753002d_ag
dan46859662dan_
dangs75623202dangs
dank95828232dank
dans56748142dans
den47554342den_
dene56643412dene
deni56929392deni
dens55945072dens
dent57158412dent
deny86027122deny
dig57544472d_ig
din46459462din_
dine55555332dine
dinge75627302dinge
dingo74720792dingo
dings76331402dings
dingy105721262dingy
dink97137802dink
dino56036752dino
dins56652042dins
dint56759052dint
do310155252do__
doat56947672doat
doby106022162doby
doc66841512do_c
dock116228742dock
docs75631152docs
dodge86618122dodge
dodgy116611462dodgy
dodo66024912dodo
doe47361952do_e
doer57734702doer
does56554472does
doff116225782doff
doge66233802doge
doggo84410702doggo
doggy115214872doggy
dogs66440152dogs
dogy96126492dogy
doings84913182doings
doit56347852doit
dojo126016142dojo
dol47150652do_l
dole56550002dole
doling84923132doling
doll56632492doll
dols56943052dols
dolt56649422dolt
dom69752442do_m
dome77240732dome
doming104218392doming
doms76239572doms
donas65926472donas
donee66931012donee
dongas84914612dongas
dongle83612492dongle
donna66215032donna
donne65520462donne
donor64418192donor
donsy96414682donsy
donut6324512donut
doom76430072doom
door56928512door
dopa77220902dopa
dope76038892dope
doping103919462doping
dopy106224152dopy
dor47253922do_r
dore56353302dore
dork96531462dork
dorm76834622dorm
dorp76028052dorp
dorr56627722dorr
dors56747602dors
dory85836232dory
dos48062312do_s
dose56442432dose
dosing83920272dosing
doss56235042doss
dost57248352dost
dot47573182do_t
dote55442882dote
doth86225712doth
doting84821912doting
dots55647662dots
doty86128222doty
dough105217382dough
doum76226672doum
dour56330432dour
doux125817982doux
dove85131562dove
dow76749972do_w
dowing114221512dowing
down86427492down
downs94918572downs
downy125714552downy
dows85941052dows
doxy156419952doxy
doze145829082doze
dozing174214192dozing
dozy175920322dozy
drag64825052drag
dreg66821652dreg
drone65324982drone
drongo836792drongo
drug65718132drug
dug58138692d_ug
dugong934372dugong
dun46545582dun_
dune56137582dune
dungs75821972dungs
dungy104713642dungy
dunk96228572dunk
duns55140432duns
dunt55746872dunt
dying105316032dying
dyne85320932dyne
eng46726782_eng
eon36052082eon_
eons46638712eons
fang85432542fang
flong95815682flong
fog76945562fo_g
fon66352272fon_
fond86330952fond
fons76943892fons
font77143752font
gang66031962gang
going75218492going
gone55639042gone
gongs74921612gongs
hang85535542hang
hog78049062ho_g
hogg96617532hogg
hon67759382hon_
hone77549322hone
hongi96715852hongi
hongs95126202hongs
honk116931192honk
hons77350782hons
hung86126352hung
ion36051022ion_
ions46737852ions
jog117438312jo_g
king95933652king
klong105310402klong
konk79320612konk
lang56637372lang
ling57447962ling
log46252682lo_g
lone45849132lone
longe66626462longe
longs65527062longs
lung55732492lung
mog66949672mo_g
mon57561572mon_
mongo810122412mongo
monk105928512monk
mono66036712mono
mons68152252mons
mony96830002mony
nog46847312no_g
nogg65115942nogg
nona46929062nona
none45743172none
on28057182_on_
one37050912_one
ono36838032_ono
ons36148512_ons
pang75336282pang
ping75943592ping
pond75530492pond
pone65747532pone
pongs85526342pongs
pons65850602pons
pony96434052pony
prong85218112prong
pung75429632pung
rang56939152rang
ring56541152ring
rung56429972rung
sang55441222sang
sing57544172sing
snog55623632snog
son37761952son_
sone46649982sone
songs67725552songs
sons46049552sons
sung55832172sung
tang56138662tang
thong95014172thong
ting56139892ting
tog410255042to_g
ton310265102ton_
tone46953742tone
tonga65619682tonga
tongs65928462tongs
tons46553052tons
tony75635152tony
tung55328162tung
udon56017742udon_
udons65411462udons
vang84926032vang
wing86339222wing
wog76242732wo_g
won66252062won_
wonk116125302wonk
wons74942042wons
wont75842502wont
wrong94712322wrong
yang85626062yang
yon67348952yon_
yond86122312yond
yoni77524392yoni
young977742young
zing145728612zing
zona136321962zona
zone135231082zone
zonk175018622zonk

Search took 2 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 Filter178691298720.0632836365.1
2DLD Change Limit298722620.93631914.5
3Display Results2622620.0634158.7
 (SQL Overall)1786912621.062168258.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.