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

223 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
going7521849(None) 
boing84725551boing
doing74923581doing
goings84911521goings
gong66827191go_ng
goring84119571goring
acing87429152acing
ageing84213402ageing
aging77026352aging
ahing98928352ahing
aping87327232aping
awing96827322awing
axing138521372axing
being84920502being
boding104320062boding
boings96416872boings
boink115516332boink
bong75633412bo_ng
boning94223292boning
booing94521642booing
boring94724872boring
bowing124723062bowing
boxing163915152boxing
bring85528502bring
cling86424672cling
coding104024792coding
coign85013912coign
coin66645352coin_
coins75834552coins
coking134523882coking
coming114225452coming
coning94331822coning
cooing94024922cooing
coping113927662coping
coring94433962coring
coting94629252coting
coving124321522coving
cowing124526322cowing
coxing164218862coxing
coying124021482coying
cuing85420192cuing
ding66940962_ding
doings84913182doings
doling84923132doling
doming104218392doming
dong66031652do_ng
doping103919462doping
dosing83920272dosing
doting84821912doting
dowing114221512dowing
dozing174214192dozing
dying105316032dying
egging93210982egging
eking106614992eking
exing136016812exing
eying96117922eying
fling97023512fling
foin77231562foin_
foins85523382foins
foxing175012432foxing
gaeing84617222gaeing
gaging94718402gaging
gain56042162gain_
gains65729512gains
gaming104622042gaming
gang66031982g_ang
gaoling93314652gaoling
gaping105618922gaping
gating84826952gating
gazing174717172gazing
geeing84313772geeing
gibing103712352gibing
gieing83614852gieing
gig56040762g_i_g
gin46055762g_in_
gink97129532g_ink
gins55543962g_ins
giving114313882giving
glint66830182glint
globing113210002globing
gloving12308442gloving
glowing123211792glowing
glozing18338892glozing
gluing83812052gluing
goading103112852goading
goaling93515332goaling
gobang10376702gobang
gobbing132910702gobbing
godding113911942godding
godling103513402godling
golfing12368942golfing
gone55639042go_ne
gonging103713032gonging
gongs74921612go_ngs
gonia64117532gonia
gonif94320922gonif
goofing123510632goofing
goon57236172goon_
goons65326772goons
goony95519782goony
goosing93314082goosing
gorging102611362gorging
gorming112810832gorming
gosling93312402gosling
gouging103410702gouging
gown85724072gown_
gowning12258832gowning
gowns95115102gowns
grig65424772gri_g
grin55733722grin_
grind75917562grind
gringa838552gringa
gringo838642gringo
grins65427222grins
groin65521082groin_
groins73917202groins
groping113313102groping
growing123512472growing
guying11379722guying
gwine95513662gwine
gybing13355932gybing
gyring113910362gyring
gyving14415712gyving
hoeing104117022hoeing
hoking144419512hoking
holing104025072holing
homing123718382homing
hong85833952ho_ng
honing103421502honing
hoping123719742hoping
hosing103421102hosing
hying126514742hying
icing86017752icing
igging93212072igging
ingoing9311022ingoing
iring66025422iring
join116724832join_
joins125818412joins
joint125227722joint
joking184113022joking
jowing174216042jowing
joying173810802joying
king95933672_king
koine9516492koine
ling57447972_ling
loin46838722loin_
loins56728422loins
long56933342lo_ng
looing73621042looing
loping93921412loping
losing74022872losing
loving104416722loving
lowing104623272lowing
loxing143615272loxing
lying95717452lying
mooing93718372mooing
moping114017102moping
moving123913282moving
mowing124119092mowing
nosing73419842nosing
noting74120152noting
ogling83211882ogling
ohing96018812ohing
oink85429352_oink
ongoing938792ongoing
oohing104412932oohing
oozing163812202oozing
oping86322412oping
owing96222722owing
piing85218832piing
ping75943602_ping
poind84217912poind
point75338732point
poking133819302poking
poling93526502poling
pong76231142po_ng
pooing93820682pooing
poring94227272poring
posing93922642posing
poxing163714942poxing
ring56541162_ring
robing93618002robing
roping94023022roping
rosing73925592rosing
roving103618742roving
rowing103623302rowing
ruing67221052ruing
sing57544182_sing
sling66028802sling
soling74226822soling
song55133672so_ng
soring74731882soring
sowing104222912sowing
sting65330242sting
suing65026362suing
swing96124842swing
thing96622982thing
ting56139922_ting
toeing74418472toeing
toking114420722toking
toling73926122toling
tong56434362to_ng
toning74025792toning
toping94122992toping
toting74123792toting
towing103823192towing
toying105017302toying
tying96019842tying
upgoing1135352upgoing
using66317962using
voling103918022voling
voting103916032voting
vowing133715272vowing
vying125111812vying
wing86339232_wing
wooing104214662wooing
wowing133915392wowing
wring95920712wring
yoking143912282yoking
young977742young
yowing133715542yowing
zing145728622_zing
zoning162914332zoning

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 Filter178691538000.296603685.8
2DLD Change Limit538002231.57634137.1
3Display Results2232230.0633539.7
 (SQL Overall)1786912231.93592346.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.