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

356 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
wing8633923(None) 
awing96827321awing
ding66940961ding
king95933671king
ling57447971ling
owing96222721owing
ping75943601ping
ring56541161ring
sing57544181sing
swing96124841swing
ting56139921ting
wig76740391wi_g
win66456301win_
wind85533861wind
wine74953431wine
wings95727241wings
wingy126521031wingy
wink116435031wink
wino75933621wino
wins75949181wins
winy107034331winy
wring95920711wring
zing145728621zing
acing87429152acing
aging77026352aging
ahing98928352ahing
ain37579102ain_
ains46158892ains
aping87327232aping
aweing103911252aweing
awning105013392awning
axing138521372axing
bang74837012bang
being84920502being
big67345732bi_g
bin56658652bin_
bind76234522bind
bine66650872bine
binge85125512binge
bingo86020092bingo
bins66548262bins
bint67355052bint
biog76122332biog
boing84725552boing
bong75633412bong
bowing124723062bowing
bring85528502bring
bung75730632bung
cawing124322612cawing
cig67036192ci_g
cine66242952cine
cling86424672cling
cowing124526332cowing
cuing85420192cuing
dang65131552dang
dawing114819822dawing
dewing114115702dewing
dig57544482di_g
din46459472din_
dine55555342dine
dinge75627302dinge
dingo74720792dingo
dings76331402dings
dingy105721262dingy
dink97137812dink
dino56036762dino
dins56652052dins
dint56759062dint
doing74923582doing
dong66031652dong
dowing114221512dowing
dung66328432dung
dwine95616142dwine
dying105316032dying
eking106614992eking
eng46726782_eng
exing136016812exing
eying96117922eying
fang85432562fang
fig76242842fi_g
fin66458042fin_
find87532612find
fine75147962fine
fink117532132fink
fino76034702fino
fins75849102fins
fling97023512fling
gang66031982gang
gig56040762gi_g
gin46055762gin_
gink97129532gink
gins55543962gins
going75218492going
gong66827192gong
gwine95513662gwine
hang85535562hang
hawing134322352hawing
hewing134514242hewing
hin67559572hin_
hind85529762hind
hinge95323452hinge
hins76448002hins
hint77455752hint
hong85833952hong
hung86126352hung
hying126514742hying
icing86017752icing
igg57116802_igg
in28150872_in_
ink76433642_ink
inn36727442_inn
ins35945612_ins
iring66025422iring
jawing174414962jawing
jewing174411422jewing
jig115633522ji_g
jin106443942jin_
jingo134615212jingo
jink156227212jink
jinn115420252jinn
jins115635022jins
jinx185516582jinx
jowing174216042jowing
kiang104811362kiang
kin76353982kin_
kina85632012kina
kind96128572kind
kine85643442kine
kings105825572kings
kink76034412kink
kino86233632kino
kins85747922kins
lang56637392lang
lawing104625282lawing
liang64914412liang
lin37967382lin_
line46965582line
linga66820822linga
lingo66022112lingo
lings67135772lings
lingy96925142lingy
link86943452link
linn46034602linn
lino46343382lino
lins47059062lins
lint416266242lint
liny78141332liny
long56933342long
lowing104623272lowing
lung55732492lung
lying95717452lying
mawing124020802mawing
mewing123914202mewing
mig65646092mi_g
migg85716812migg
mina65136932mina
mind75434392mind
mine67256182mine
mingy115520182mingy
mini65634572mini
mink106636542mink
mint66758072mint
minx137723362minx
mowing124119092mowing
nine45842182nine
ohing96018812ohing
oink85429352oink
oping86322412oping
owning104110342owning
pang75336302pang
pawing124519552pawing
pig65744982pi_g
piing85218832piing
pin57066732pin_
pina65842642pina
pine67755722pine
pingo87122712pingo
pings85830882pings
pink107039392pink
pins65558462pins
pint66963182pint
piny911838362piny
pong76231142pong
pung75429632pung
rang56939172rang
rig46748132ri_g
rin36663192rin_
rind56535612rind
rings65029172rings
rink87737002rink
rins46153202rins
rowing103623302rowing
ruing67221052ruing
rung56429982rung
sang55441242sang
sawing104323812sawing
sewing103819622sewing
sign55523062sign
sin36265902sin_
sine46560632sine
singe65731132singe
sings65532702sings
sinh76238052sinh
sink86640152sink
sins46755282sins
sling66028802sling
song55133672song
sowing104222912sowing
sting65330242sting
suing65026362suing
sung55832172sung
swang95519722swang
swig85818022swi_g
swine85625302swine
swinge105614382swinge
swings104714452swings
swingy13489872swingy
swink125116352swink
swung95610562swung
tang56138692tang
tawing104521552tawing
tewing103914822tewing
thing96622982thing
tin36362182tin_
tine45855142tine
tinge64626632tinge
tings65329212tings
tins45251312tins
tint46758872tint
tiny76134642tiny
tong56434362tong
towing103823192towing
tung55328172tung
twang94511862twang
twig87615772twi_g
twin76023082twin_
twine85822362twine
twinge104210402twinge
twins85118982twins
twiny116012812twiny
tying96019842tying
using66317962using
vang84926052vang
vig75637532vi_g
vina76331812vina
vine75643692vine
vino76128442vino
viny106025962viny
vowing133715272vowing
vying125111812vying
wading114619532wading
wag76451752w_ag
waging114318382waging
wain75840202wain_
wains86930872wains
waking144821382waking
waling104525302waling
wan66761942wan_
wand85833882wand
wane76344722wane
waning103623802waning
wank115632512wank
wans76452272wans
want76156172want
wany106432362wany
waring105029442waring
waving134018202waving
waxing174215282waxing
wen66249602wen_
wend85330452wend
wens76337932wens
went76051872went
whang124813382whang
whig115516422whig
whin105225692whin_
whine116022812whine
whinge134311542whinge
whins114922332whins
whiny144915572whiny
wich125724752wich
wick135726312wick
wide85235422wide
wife105228032wife
wifing133513392wifing
wiggy134510732wiggy
wigs84931262wigs
wild85126522wild
wile75944382wile
wiling103024292wiling
will75737522will
wilt76246302wilt
wily106428822wily
wimp115521532wimp
wince105220882wince
winch135016662winch
winds95425612winds
windy126118112windy
wined94434182wined
wines85546862wines
winey115325432winey
winged114620832winged
winger104125442winger
wining103625052wining
winks125325432winks
winos84625042winos
winze175014852winze
wipe94830292wipe
wiping123916712wiping
wire75839822wire
wiring104521022wiring
wiry106422842wiry
wis66552342wi_s
wise75737352wise
wish107228742wish
wising103318222wising
wisp97124082wisp
wiss75630552wiss
wist78049302wist
wit66563782wi_t
wite75443282wite
with105730482with
witing103522822witing
wits76044882wits
wive105931762wive
wiving133316602wiving
wiz156434162wi_z
wog76242732w_og
won66252062won_
wonk116125302wonk
wons74942042wons
wont75842502wont
wooing104214662wooing
wowing133915392wowing
wrang94716112wrang
wrings104012972wrings
wrong94712322wrong
wrung9549802wrung
wrying13379622wrying
wyling13368552wyling
wyn95921442wyn_
wynd116114462wynd
wynn105811292wynn
wyns105717032wyns
wyting13277242wyting
yang85626082yang
yawing134215612yawing
yin67648742yin_
yins75335132yins
yowing133715542yowing
zig136931912zi_g
zin125643782zin_
zinc156819102zinc
zine137036162zine
zings154620892zings
zingy186516132zingy
zins135735012zins

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.280638182.1
2DLD Change Limit298723560.76638997.4
3Display Results3563560.0764684.2
 (SQL Overall)1786913561.122159261.1
 
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.