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

396 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
ling5744796(None) 
cling86424671cling
ding66940951ding
fling97023511fling
king95933651king
lang56637371lang
liang64914411liang
lin37967371lin_
line46965571line
linga66820811linga
lingo66022101lingo
lings67135771lings
lingy96925131lingy
link86943441link
linn46034591linn
lino46343371lino
lins47059051lins
lint416266231lint
liny78141321liny
long56933341long
lung55732491lung
lying95717451lying
ping75943591ping
ring56541151ring
sing57544171sing
sling66028801sling
ting56139891ting
wing86339221wing
zing145728611zing
acing87429152acing
aging77026352aging
ahing98928342ahing
ailing74331012ailing
ain37579092ain_
ains46158882ains
alang66023512alang
align65016502align
aline57243152aline
along65419492along
aping87327232aping
awing96827322awing
axing138521372axing
baling94829692baling
bang74836992bang
being84920502being
big67345712bi_g
bin56658632bin_
bind76234502bind
bine66650852bine
binge85125512binge
bingo86020092bingo
bins66548242bins
bint67355032bint
biog76122312biog
blin67228172blin_
blind86319322blind
blini75519272blini
blink115720142blink
bluing94914482bluing
boing84725552boing
bong75633412bong
bring85528502bring
bung75730632bung
cig67036182ci_g
cine66242942cine
clang86019312clang
cline76428532cline
clings95716212clings
clingy12659062clingy
clink115320042clink
cluing93913502cluing
clung86013602clung
cuing85420192cuing
dang65131532dang
dig57544472di_g
din46459462din_
dine55555332dine
dinge75627302dinge
dingo74720792dingo
dings76331402dings
dingy105721262dingy
dink97137802dink
dino56036752dino
dins56652042dins
dint56759052dint
doing74923582doing
doling84923132doling
dong66031652dong
dung66328432dung
dying105316032dying
eking106614982eking
elint55436472elint
eng46726782_eng
exing136016812exing
eying96117922eying
fang85432542fang
fig76242832fi_g
filing103823762filing
fin66458032fin_
find87532602find
fine75147952fine
fink117532122fink
fino76034692fino
fins75849092fins
flings106715282flings
flint87333502flint
flong95815682flong
flung95114582flung
flying134612152flying
gang66031962gang
gig56040752gi_g
gin46055752gin_
gink97129522gink
gins55543952gins
glint66830182glint
gluing83812052gluing
going75218492going
gong66827192gong
haling104229782haling
hang85535542hang
hin67559562hin_
hind85529752hind
hinge95323442hinge
hins76447992hins
hint77455742hint
holing104025072holing
hong85833952hong
hung86126352hung
hying126514742hying
icing86017742icing
idling8912872idling
igg57116792_igg
in28150862_in_
ink76433632_ink
inn36727432_inn
ins35945602_ins
iring66025412iring
isling71213872isling
jig115633512ji_g
jin106443932jin_
jingo134615212jingo
jink156227202jink
jinn115420242jinn
jins115635012jins
jinx185516572jinx
kiang104811352kiang
kin76353962kin_
kina85631992kina
kind96128552kind
kine85643422kine
kings105825562kings
kink76034392kink
kino86233612kino
kins85747902kins
klong105310402klong
lacing94626232lacing
lading84227122lading
lag47862122l_ag
lain46146282lain_
laking115027042laking
laming94528362laming
land56337302land
lane45153322lane
lank84734442lank
lasing74727982lasing
laving104623572laving
lawing104625282lawing
laying104525702laying
lazing164821472lazing
leg46446112l_eg
lend56233672lend
leno47331392leno
lens46146492lens
lent46360532lent
li29948752li__
liana53915892liana
liane54720662liane
liangs74410592liangs
liar47229682liar
lib57750262li_b
libs66732752libs
lice66045062lice
lich96230842lich
lick106935072lick
lid47453512li_d
lido56028152lido
lids56336452lids
lie38264522li_e
lied55838092lied
lief76036982lief
liege65314432liege
lien45339802lien
liens56525502liens
lier45942462lier
lies46454192lies
lieu46534362lieu
life75433732life
lift76942722lift
like86040842like
liking114319582liking
lilo46731562lilo
lilt46349942lilt
lily76730182lily
lima65734132lima
limb85429372limb
lime66244932lime
liming94021232liming
limn66527692limn
limns75718392limns
limo65529732limo
limp88432492limp
limy95727712limy
linac7315412linac
linage7713402linage
lindy96918312lindy
lined64934642lined
linen55728722linen
liner55938912liner
lines57054572lines
liney87029622liney
lingam95112332lingam
lingas75116562lingas
linger75225992linger
lingua7509902lingua
linin58025522linin
lining74526802lining
links96430192links
linky127622382linky
linns56123332linns
linos55631502linos
lints57137192lints
linty87126562linty
linum7313822linum
lion46334442lion
lions55923212lions
lip514755802li_p
lipa68425922lipa
lipe66839732lipe
lips67141442lips
lira46928682lira
lire47845292lire
liri45128252liri
lis37162272li_s
lisp68926872lisp
list47055342list
lit39377312li_t
lite47054542lite
lits46252492lits
litu47631562litu
live76540992live
living104318322living
log46252682l_og
loin46838722loin_
loins56728422loins
lone45849132lone
longe66626462longe
longs65527062longs
looing73621042looing
loping93921412loping
losing74022872losing
loving104416722loving
lowing104623272lowing
loxing143615272loxing
lubing94114032lubing
lug46138062l_ug
luging83915292luging
luna46229852luna
lune47140492lune
lunge65323802lunge
lungi65516052lungi
lungs65223882lungs
lunk86030722lunk
lunt46148842lunt
luny77324132luny
luring73820752luring
luting75221752luting
lyings10488502lyings
lynx1437422lynx
lysing104710442lysing
mig65646072mi_g
migg85716792migg
mina65136902mina
mind75434362mind
mine67256152mine
mingy115520182mingy
mini65634542mini
mink106636512mink
mint66758042mint
minx137723332minx
muling93519882muling
nine45842172nine
ogling83211882ogling
ohing96018802ohing
oiling74925312oiling
oink85429342oink
olingo736932olingo
oping86322412oping
owing96222722owing
paling93530132paling
pang75336282pang
pig65744972pi_g
piing85218832piing
piling95025592piling
pin57066722pin_
pina65842632pina
pine67755712pine
pingo87122712pingo
pings85830882pings
pink107039382pink
pins65558452pins
pint66963172pint
piny911838352piny
plink115219122plink
plying124312082plying
poling93526502poling
pong76231142pong
puling93621402puling
pung75429632pung
rang56939152rang
rig46748122ri_g
riling74227972riling
rin36663182rin_
rind56535602rind
rings65029172rings
rink87736992rink
rins46153192rins
ruing67221052ruing
ruling73219552ruling
rung56429972rung
sang55441222sang
sign55523052sign
sin36265892sin_
sine46560622sine
singe65731132singe
sings65532702sings
sinh76238042sinh
sink86640142sink
sins46755272sins
slang66324022slang
slings74618012slings
slink95422912slink
sluing74315882sluing
slung65117832slung
soling74226822soling
song55133672song
sting65330242sting
suing65026362suing
sung55832172sung
swing96124842swing
tang56138662tang
thing96622962thing
tiling73426552tiling
tin36362172tin_
tine45855132tine
tinge64626612tinge
tings65329192tings
tins45251302tins
tint46758862tint
tiny76134632tiny
toling73926122toling
tong56434352tong
tung55328162tung
tying96019832tying
using66317962using
vang84926032vang
vig75637522vi_g
vina76331802vina
vine75643682vine
vino76128432vino
viny106025952viny
voling103918022voling
vying125111812vying
waling104525302waling
wig76740382wi_g
wiling103024292wiling
win66456292win_
wind85533852wind
wine74953422wine
wings95727242wings
wingy126521032wingy
wink116435022wink
wino75933612wino
wins75949172wins
winy107034322winy
wring95920712wring
wyling13368552wyling
yang85626062yang
yin67648732yin_
yins75335122yins
zig136931902zi_g
zin125643772zin_
zinc156819092zinc
zine137036152zine
zings154620892zings
zingy186516132zingy
zins135735002zins

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.0762351197.4
2DLD Change Limit298723960.86034734.9
3Display Results3963960.0964125.0
 (SQL Overall)1786913961.032173150.2
 
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.