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 “linsang” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

201 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
linsang83586(None) 
linsangs944411linsangs
ginseng933432ginseng
insane6314882_insane
lensing84015102lensing
liang64914412li__ang
lindane839032lindane
lining74526802lin_ing
linking123818252linking
linting83820982linting
pinang92611592pin_ang
rinsing82516112rinsing
aliasing9310073aliasing
alining81917043alin_ing
biasing103512453biasing
binding113819383binding
binging113619383binging
binning103615453binning
blinding123210163blinding
blinking153510623blinking
blissing1136873blissing
censing104215263censing
clinging122910913clinging
clinking153611663clinking
dinging103618613dinging
dining84525133din_ing
dinking133618283dinking
dinning93416553dinning
dinting93520553dinting
dissing94517683dissing
finding124116543finding
fining104223213fin_ing
finking154016603finking
finning113615113finning
flensing1246973flensing
flinging133310053flinging
flinting123412343flinting
genseng933983genseng
ginning93313983ginning
ginsengs1042653ginsengs
glinting103210053glinting
hinging123917123hinging
hinting113919223hinting
hissing114213143hissing
inane52820343_in_ane
incant82418503_incant
infant92315133_infant
inking115119053_inking
inland7310313_inland
inning73617633_inning
insaner7310443_insaner
inspan837513_inspan_
inspans937803_inspans
instant7815343_instant
jinking193613543jinking
jinxing22306503jinxing
kiang104811353ki__ang
kinging133115033kinging
kinking113615153kinking
kinsman1335963kinsman_
kissing122911053kissing
lancing103314123lancing
landing92819323landing
lang56637383l___ang
lantana739603lantana
lapsing103511163lapsing
lasing74727983l_asing
leasing83920163leasing
lending94118533lending
lensman937563lensman_
liaising937913liaising
liana53915893li__ana
liane54720663li__ane
liangs74410593li__angs
licensing1244753licensing
licking144118283licking
lidding103611433lidding
lifting113313273lifting
ligan67920283li_gan_
ligand85011293li_gand
ligans76817733li_gans
lignan75510323lignan_
lignans8398853lignans
liking114319583li_king
lilting83515383lilting
liman75921603li_man_
limans84816303li_mans
limbing123410423limbing
liming94021243li_ming
limning103710323limning
limping124614113limping
linac7315413lin_a_c
linacs8310813lin_acs
linage7713403lin_age
lindanes939173lindanes
linden7411453linden_
lindens839413lindens
lineage878983lineage
lineal65616023linea_l
linear65113343linea_r
lineate7815153lineate
lineman939123lineman_
linen55728723lin_en_
linens64818393lin_ens
lineny94011443lin_eny
linesman1046253linesman_
ling57447963li___ng
linga66820823linga__
lingam95112353linga_m
lingams104510193lingams
lingas75116573linga_s
linin58025523lin_in_
linings84313073lin_ings
linins65922143lin_ins
linkage1295963linkage
linkman1335393linkman_
linksland1452053linksland
linksman1444153linksman_
linn46034593lin__n_
linns56123333lin__ns
lins47059053lins___
linseed838203linseed
linsey938993lins_ey
linseys1035083linseys
lionising1046463lionising
lipping123016073lipping
lisping103412753lisping
listing84020593listing
litany939053li_tany
living104318323li_ving
longan75612363longan_
longans84510813longans
longing93915783longing
loosing83515963loosing
losing74022873l_osing
lousing83817733lousing
lungan74710213lungan_
lungans8399053lungans
lunging93714213lunging
lunting83817743lunting
lysing104710443l_ysing
mensing103915103mensing
mincing123314333mincing
minding113317893minding
mining94225453min_ing
minting103020813minting
minyan1138173minyan_
minyans1237263minyans
missing103619073missing
oinking123714713oinking
outsang83411273outsang
penang92511113pen_ang
pinangs10267793pin_angs
pinging113419553pinging
pining93726533pin_ing
pinking143918943pinking
pinning103417853pinning
pintano998993pintano
pissant91012503pissant
pissing103914803pissing
plainsong1241963plainsong
plinking153611243plinking
ringing93521283ringing
rinning83216743rinning
rinsings9318013rinsings
rising74025883ri_sing
sang55441233___sang
sensing84116953sensing
siamang1045333siamang
singing93221423singing
singsong1043443singsong
sinking123320543sinking
sinning83918443sinning
sinsyne1043303sinsyne
slinging103312863slinging
slinking133412983slinking
tensing84616653tensing
tinging93619463tinging
tining74927543tin_ing
tinman82411143tinman_
tinning83117283tinning
tinting84620603tinting
tisane6311573ti_sane
unhang1038443_unhang
unsnag736393_unsnag
unsung736983_unsung
vining104619463vin_ing
visaing11279333vi_saing
vising103915873vi_sing
wincing133413903wincing
winding123517913winding
winging123718713winging
wining103625053win_ing
winking153317963winking
winning113516553winning
wising103318223wi_sing
wissing113212943wissing
zincing192910283zincing
zingani1744813zingani
zingano1744203zingano
zinging183513943zinging

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272017.03319056.9
3Display Results2012010.0603350.0
 (SQL Overall)1786912017.49923828.6
 
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.