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

228 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
lignans839885(None) 
ligans76817731lig_ans
lignan75510321lignan_
lignins84010491lignins
lagans75717782lag_ans
lianas63713382liana_s
ligan67920282lig_an_
ligand85011292lig_and
ligands9438982ligands
lignin74911192lignin_
limans84816302li_mans
linacs8310812li_nacs
linens64818392li_nens
lingams104510192lingams
lingas75116572linga_s
linins65922142li_nins
linns56123332li_n_ns
logans76319062log_ans
longans84510812longans
lungans8399052lungans
mignons1037862mignons
signals8359162signals
wigans104511702wig_ans
afghans1443573afghans
aligners9117573aligners
aligning10158533aligning
aligns75312953alig__ns
biggins113410693biggins
bigness1038193bigness
bogans95714813bog_ans
chignons1444713chignons
cigars9910723cig_ars
cognacs1256043cognacs
dinars75417563di_nars
dioxans1555313dioxans
dipnoans1144103dipnoans
divans104612393di_vans
diwans105110373di_wans
dognaps1134393dognaps
finals94316163fi_nals
firmans12238523firmans
gigas75415583gig_a_s
gingals9109313gingals
glans65125833__glans
gnars66718853__gnars
gnats65217713__gnats
gnaws96311143__gnaws
grans64832543__grans
guans64419443__guans
hogans105914313hog_ans
honans94814503_honans
iguana735813_iguana
iguanas835383_iguanas
inane52820343_i_nane
inanes62519803_i_nanes
inns46920933_i_n_ns
jigsaws1842563jigsaws
jingals1588073jingals
jinns126013843ji_n_ns
kidnaps1453323kidnaps
kinas95626923ki_na_s
kinins104014583ki_nins
lagan66520343lag_an_
lagoons839253lagoons
lagunas8156823laguna_s
lallans74113543lallans
lanais6316793l_anais
lauans65113533l_auans
leans55536253l__eans
legals73412733leg_als
leggins9259473leggins
legions84611783legions
legman949653legman_
lemans85316393l_emans
liana53915893li__ana
liane54720663li__ane
lianes63819323lian_es
liang64914413li__ang
liangs74410593lian_gs
liars54723163li__ars
liblabs1144123liblabs
libras83711703libra_s
lichens123510683lichens
lidars7310783li_dars
lienal63912793liena_l
liens56525503li__ens
ligase7259913lig_ase
ligases82310713ligases
ligate72519253lig_ate
ligates82318383ligates
ligers75022043lig_ers
lightens122510003lightens
lights104519913lig_hts
lignaloes1054033lignaloes
ligneous945233ligneous
lignify1443793lignify
lignite81310303lignite
lignites9129613lignites
ligroins946823ligroins
ligulas8329173ligulas
ligules82210923ligules
ligures8269893ligures
likens105613703li_kens
lilacs837483li_lacs
liman75921603li_man_
limas75627633li_ma_s
limbas105313203limba_s
limens84618033li_mens
limners93311563limners
limning103710323limning
limns75718393li__mns
limpas105513083limpa_s
linac7315413li_na_c
linage7713403li_nage
linages8813173li_nages
lindane839033lindane
lindanes939173lindanes
lindens839413lindens
linen55728723li_nen_
lineny94011443li_neny
liners65428853li_ners
lines57054573li_n_es
linga66820823linga__
lingam95112353linga_m
lingers84223303lingers
lingoes84014693lingoes
lings67135773li_n_gs
linguals9317223linguals
linin58025523li_nin_
lining74526803li_ning
linings84313073li_nings
links96430193li_n_ks
linn46034603li_n_n_
linnets739833linnets
linos55631503li_n_os
lins47059063li___ns
linsang835863linsang
linsangs944413linsangs
lints57137193li_n_ts
linums838283li_nums
lioness739103lioness
lions55923213li__ons
lipins85016883li_pins
lippens11328533lippens
liras56021983li_ra_s
listens74014133listens
litany939053li_tany
litas54923773li_ta_s
livens94314893li_vens
loans56026463l__oans
lochans1248833lochans
logan68123283log_an_
loggats9286453loggats
logins77820643log_ins
logions86211293logions
logjams1743583logjams
logons79818173log_ons
logways1434513logways
longan75612363longan_
lorans65117603l_orans
lorgnons943993lorgnons
lunars65012813l_unars
lunas55025013l_una_s
lungan74710213lungan_
lurdans837073lurdans
magians10310753magians
malignant1245223malignant
mannans93611523mannans
mignon937953mignon_
migrant10314313migrant
migrants1138183migrants
minas75434113mi_na_s
minyans1237263minyans
nans46139403___nans
ninons64913773ni_nons
oilcans936813oilcans
organs7912913org_ans
origans839973orig_ans
pagans95717923pag_ans
pians75126963pi__ans
pigeons1039183pigeons
piggins113010473piggins
pignus937953pign_us
pignuts1035613pignuts
pigpens1235503pigpens
pinang92611593pi_nang
pinangs10267793pi_nangs
pinas75434453pi_na_s
pinnas85315523pinna_s
pinons86019943pi_nons
pitmans11188743pitmans
poignant1145743poignant
raglans82410133raglans
regnant8312843regnant
siennas736123siennas
sigmas94111363sigma_s
signa66114703signa__
signage937773signage
signages1037483signages
signal73711483signa_l
signees83510803signees
signers84714443signers
signets83311503signets
signing92713963signing
signors83410913signors
signs65516323sig__ns
silvans10308333silvans
simians959203simians
slogans8407983slog_ans
tiglons837343tiglons
tigons74112263tig_ons
titans63414913ti_tans
titians72710453titians
vegans103910853veg_ans
vigas94817883vig_a_s
vigias104110893vigia_s
vinals94716483vi_nals
vinas85126343vi_na_s
wangans1149503wangans
wiccans1434603wiccans
wigan95114393wig_an_
wigeons1136983wigeons
wigwags1543293wigwags
wigwams1643883wigwams
witans93412933wi_tans
zigzags1742273zigzags
zingani1744813zingani
zingano1744203zingano

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 Limit1340272286.81319672.2
3Display Results2282280.0932451.6
 (SQL Overall)1786912287.31224438.0
 
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.