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

308 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
lings6713577(None) 
clings95716211clings
dings76331401dings
flings106715281flings
kings105825561kings
liangs74410591liangs
lines57054571lines
ling57447961ling_
linga66820811linga
lingas75116561lingas
lingo66022111lingo
lingy96925141lingy
links96430191links
linns56123331linns
linos55631501linos
lins47059051lin_s
lints57137191lints
longs65527061longs
lungs65223881lungs
lyings10488501lyings
pings85830881pings
rings65029171rings
sings65532701sings
slings74618011slings
tings65329191tings
wings95727241wings
zings154620891zings
ablings1038742ablings
agings86312672agings
ains46158882ain_s
aligns75312952aligns
alines65735222alines
bangs85627772bangs
beings94613032beings
bigs76235022bi_gs
binds86627472binds
bines76946792bines
binge85125512binge
binges93923122binges
bingo86020092bingo
bingos95514792bingos
bins66548252bin_s
bints76130182bints
biogs85016112biogs
blinds95111612blinds
blinis85313682blinis
blinks124613572blinks
bluings10327962bluings
boings96416872boings
bongs87828422bongs
brings94618432brings
bungs85323862bungs
cigs75625102ci_gs
cines75239682cines
clangs95113612clangs
clines84926042clines
cling86424672cling_
clingy12659062clingy
clinks125815062clinks
dangs75623202dangs
digs66036052di_gs
dines66449152dines
ding66940952ding_
dinge75627302dinge
dinges83825422dinges
dingo74720792dingo
dingus83611842dingus
dingy105721262dingy
dinks105927952dinks
dinos65428062dinos
dins56652042din_s
dints67431312dints
doings84913182doings
dongs76525812dongs
dungs75821972dungs
dyings11478132dyings
elints65816422elints
engs56121392_engs
fangs96224072fangs
figs85332642fi_gs
filings115213072filings
finds95424822finds
fines86644262fines
finis86824262finis
finks125424222finks
finos86226952finos
fins75849092fin_s
fling97023512fling_
flints95617452flints
flongs105010492flongs
flyings14496062flyings
gangs76222572gangs
gigs66631182gi_gs
ginks104319562ginks
gins55543952gin_s
glints75714212glints
goings84911522goings
gongs74921612gongs
hangs95726722hangs
hinds96721472hinds
hinge95323442hinge
hinges105121022hinges
hins76447992hin_s
hints87330622hints
hongs95126202hongs
icings9428452icings
iggs66612672_iggs
inks86926502_inks
inns46920932_inns
ins35945602_in_s
jigs126524762ji_gs
jingo134615212jingo
jinks165019332jinks
jinns126013842jinns
jins115635012jin_s
kiangs11378362kiangs
kinas95626912kinas
kinds106221812kinds
kines95039132kines
king95933652king_
kinks84926082kinks
kinos96626142kinos
kins85747902kin_s
klongs11436602klongs
lacings105013652lacings
ladings93814132ladings
lags56546222l_ags
lakings124713502lakings
lands65426902lands
lanes54946792lanes
lang56637372lang_
lawings113611472lawings
legs56133692l_egs
lends65326252lends
lenes54738522lenes
lenis56326862lenis
lenos56024862lenos
lens46146492len_s
lianas63713382lianas
lianes63819322lianes
liang64914412liang_
liars54723162liars
libs66732762li_bs
licks115325392licks
lidos65219882lidos
lids56336452li_ds
liege65314432liege
lieges74113442lieges
liens56525502liens
liers55130402liers
lies46454192li_es
lieus56218482lieus
lifts85719062lifts
likes96231902likes
likings12539412likings
lilos55821872lilos
lilts55822802lilts
limas75627632limas
limbs96118942limbs
limes75636502limes
limns75718392limns
limos75320812limos
limps95522672limps
lin37967372lin__
linac7315412linac
linacs8310812linacs
linage7713402linage
linages8813172linages
lindy96918312lindy
line46965572lin_e
lined64934642lined
linen55728722linen
linens64818392linens
liner55938922liner
liners65428852liners
liney87029632liney
lingam95112332lingam
lingams104510172lingams
linger75226002linger
lingers84223302lingers
lingoes84014692lingoes
lingua7509902lingua
linin58025522linin
linings84313072linings
linins65922142linins
link86943442lin_k
linky127622382linky
linn46034592lin_n
lino46343372lin_o
lint416266232lin_t
linty87126562linty
linum7313822linum
linums838282linums
liny78141322lin_y
lions55923212lions
lips67141442li_ps
liras56021982liras
lis37162272li__s
lisps76913902lisps
lists56628692lists
litas54923772litas
lits46252492li_ts
lives86133192lives
livings11408922livings
logs57343112l_ogs
loins56728422loin_s
long56933342long_
longe66626462longe
longes75925572longes
losings82810622losings
lowings113710072lowings
lugs55233522l_ugs
lunas55025012lunas
lunes55337772lunes
lung55732492lung_
lunge65323802lunge
lunges76123422lunges
lungi65516052lungi
lungis77113022lungis
lunks94822452lunks
lunts55826902lunts
lutings83311052lutings
lying95717452lying_
miggs96311372miggs
migs76935322mi_gs
minas75434112minas
minds85427122minds
mines75651952mines
mingy115520182mingy
minis75432992minis
minks115829272minks
mints76834042mints
minus75223932minus
nines55937342nines
oinks94819912oinks
olingo736932olingo
olingos846012olingos
palings103915822palings
pangs84628662pangs
pigs76634222pi_gs
pilings103313612pilings
pinas75434452pinas
pines76048862pines
ping75943592ping_
pingo87122712pingo
pingos95317672pingos
pinks115729382pinks
pins65558452pin_s
pints75936222pints
plinks124913262plinks
pongs85526342pongs
pulings103511322pulings
pungs85422222pungs
rigs55137592ri_gs
rinds64826142rinds
ring56541152ring_
rinks94827102rinks
rins46153192rin_s
rulings83310382rulings
rungs611819402rungs
signs65516322signs
sines55954822sines
sing57544172sing_
singe65731132singe
singes74326852singes
sinhs86719602sinhs
sinks95529182sinks
sins46755272sin_s
sinus55523852sinus
slangs75615342slangs
sling66028802sling_
slinks104315152slinks
songs67725552songs
stings76220182stings
swings104714452swings
tangs65028342tangs
things104914282things
tilings84212792tilings
tines54848422tines
ting56139892ting_
tinge64626612tinge
tinges74722322tinges
tins45251302tin_s
tints56030922tints
tongs65928462tongs
tungs65520622tungs
vangs96319582vangs
vigs85427272vi_gs
vinas85126342vinas
vines85137642vines
vinos84723072vinos
wigs84931252wi_gs
winds95425602winds
wines85546862wines
wing86339222wing_
wingy126521032wingy
winks125325432winks
winos84625042winos
wins75949172win_s
wrings104012972wrings
yangs95618692yangs
yins75335122yin_s
zigs145422792zi_gs
zincs165312932zincs
zines145232652zines
zing145728612zing_
zingy186516132zingy
zins135735002zin_s

Search took 3 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.0931921408.6
2DLD Change Limit538003081.86028924.7
3Display Results3083080.0803850.0
 (SQL Overall)1786913082.03387895.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.