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

128 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
linga6682082(None) 
ling57447961ling_
lingam95112351lingam
lingas75116571lingas
lingo66022111lingo
lings67135771lings
lingua7509911lingua
lingy96925141lingy
anga56831352_anga
binge85125512binge
bingo86020092bingo
cling86424672cling_
clings95716212clings
clingy12659062clingy
conga85419872conga
ding66940952ding_
dinge75627302dinge
dingo74720792dingo
dings76331402dings
dingy105721262dingy
donga76718422donga
fanga96119622fanga
finca104714502finca
fling97023512fling_
flings106715282flings
giga66720942gi_ga
gingal81010152gingal
gringa838552gringa
hinge95323452hinge
inia45024702_inia
jingal1498592jingal
jingo134615212jingo
kina85631992kin_a
king95933652king_
kings105825562kings
lang56637382lang_
liana53915892liana
liang64914412liang_
liangs74410592liangs
libra74712422libra
liege65314432liege
ligan67920282li_gan
lignan75510322lignan
lima65734132li_ma
limba95414982limba
limpa97014462limpa
lin37967372lin__
linac7315412linac
linage7713402linage
lindy96918312lindy
line46965572lin_e
lineal65616022lineal
linear65113342linear
lined64934642lined
linen55728722linen
liner55938922liner
lines57054572lines
liney87029632liney
lingams104510192lingams
linger75226002linger
linguae8398412linguae
lingual8379082lingual
lingula8428802lingula
linin58025522linin
link86943442lin_k
links96430192links
linky127622382linky
linn46034592lin_n
linns56123332linns
lino46343372lin_o
linos55631502linos
lins47059052lin_s
lint416266232lin_t
lints57137192lints
linty87126562linty
linum7313822linum
liny78141322lin_y
lipa68425922li_pa
lira46928682li_ra
long56933342long_
longan75612362longan
longe66626462longe
longs65527062longs
luna46229852lun_a
lung55732492lung_
lungan74710212lungan
lunge65323802lunge
lungi65516052lungi
lungs65223882lungs
lying95717452lying_
lyings10488502lyings
manga85026202manga
mina65136922min_a
mingy115520182mingy
ninja1258092ninja
olingo736932olingo
panga85323532panga
pina65842632pin_a
ping75943592ping_
pingo87122712pingo
pings85830882pings
pinna75320182pinna
pinta75727052pinta
ring56541152ring_
rings65029172rings
sanga66023792sanga
signa66114702signa
sing57544172sing_
singe65731132singe
sings65532702sings
sling66028802sling_
slings74618012slings
tanga64923692tanga
tinea54923162tinea
ting56139902ting_
tinge64626622tinge
tings65329202tings
tonga65619692tonga
viga85622962vi_ga
vina76331802vin_a
vinca105315162vinca
virga9310252virga
wing86339222wing_
wings95727242wings
wingy126521032wingy
zing145728612zing_
zings154620892zings
zingy186516132zingy

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.0802233637.5
2DLD Change Limit538001281.45037103.4
3Display Results1281280.0333878.8
 (SQL Overall)1786911281.563114325.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.