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

362 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
leggins925947(None) 
leggin8268591leggin_
legging103912641legging
leggings11316191leggings
begging123012652begging
begins94415302be_gins
biggins113410692biggins
egging93210982_egging
kegging14328292kegging
lagging103316742lagging
laggings11298402laggings
lectins92515002lectins
leggier9368232leggier
leggiest10308232leggiest
legginess1135032legginess
legions84611782legions
legits71313002le_gits
legumins1144992legumins
leptins92412692leptins
leucins938102leucins
levins94514652le_vins
lignins84010492lignins
loggias9356782loggias
logging103316812logging
loggings11398232loggings
logins77820642l_ogins
luggies93011212luggies
lugging104114352lugging
muggins11248072muggins
noggins9288452noggins
pegging122811132pegging
piggins113010472piggins
reagins84215642reagins
regains84316582regains
veggies1237552veggies
vegging13308872vegging
abegging1334483abegging
aegis6316783ae_gi_s
aggies83515513_aggies
alevins102110573ale_vins
alexins141910663ale_xins
algins74816433_algins
allergins10146383allergins
baggies113814853baggies
bagging123316983bagging
baggings13307523baggings
beduins1039123beduins
beggars11378223beggars
begin85117353be_gin_
begrims1276763begrims
beguine1068503beguine
beguines11127213beguines
benzins1838693benzins
berlins93216013berlins
biggies113813523biggies
biggin103710603biggin_
bigging122815883bigging
biggings13327473biggings
blagging13319173blagging
blaggings14324463blaggings
blogging13369013blogging
bloggings14264263bloggings
bogging123615753bogging
buggies114613813buggies
bugging123515183bugging
clagging13328883clagging
clergies1137903clergies
clogging13368503clogging
cogging123513713cogging
deigns8389983deig_ns
dentins83419223dentins
designs9328313designs
detains83716093detains
deveins1138813deveins
digging113513703digging
diggings12316623diggings
doggies103613023doggies
dogging113312693dogging
edging93510713_edging
edgings10256243_edgings
eggars8398973_eggars
eggers84612583_eggers
eggs66516153_egg__s
egis56520653_e_gi_s
elains64919853_elains
elegies81312903elegies
elegits8149343elegits
elfins94810943_elfins
eloigns8425353eloigns
eloins65419383_eloins
engine71114863_engine
engines81114463_engines
eosins64419163_eosins
fagging133714763fagging
fagins10513863_fagins
feigns10407753feig_ns
figging133313563figging
flagging14329233flagging
flaggings15285183flaggings
fledging14276523fledging
flogging14329173flogging
floggings15314123floggings
fogging133513733fogging
fugging133912913fugging
gagging93013533gagging
gains65729513__gains
gigging93311773gigging
gins55543953___gins
glugging10316353glugging
grins65427223__grins
hagging133114683hagging
haggis11209513haggi_s
hedging13348953hedging
hemins113417573he_mins
heroins103518013heroins
hogging133112803hogging
hugging132710633hugging
igging93212073_igging
jaggies163311083jaggies
jagging173311993jagging
jerkins18358253jerkins
jigging173011553jigging
jogging173211233jogging
joggings18264633joggings
jugging172910723jugging
kedging14357563kedging
keggers13357043keggers
kegling13309363kegling
keglings14245233keglings
kelvins14106563kelvins
lagans75717783l_agans
laggers94216243laggers
lagoons839253lagoons
lapins84520683l_apins
lashins103915153lashins
lattins74115483lattins
layins93817653l_ayins
leadens83610983leadens
leading93419553leading
leadings103511243leadings
leafing113313583leafing
leagues837943leagues
leaguing1035343leaguing
leaking123616973leaking
leaning83721203leaning
leanings94010183leanings
leans55536253le__ans
leaping103215993leaping
learns65513743le_arns
leasing83920163leasing
leasings9379843leasings
leavens10409303leavens
leaving114216853leaving
leavings12407493leavings
lebens8310093le_bens
leching134613653leching
lectin82515013lectin_
lections102413843lections
ledgers94912183ledgers
ledges84918013ledg_es
ledgier9458503ledgier
ledgiest10288593ledgiest
leering83417643leering
lefties10312073lefties
legacies1139043legacies
legals73412733le_gals
legates82917683legates
legatine91311403legatine
legating102313113legating
legations102711923legations
legatos82711183legatos
legend837693le_gend
legends936073legends
legers74518313le_gers
leges64427293le_g_es
legged95713093legg_ed
leggiero10342763leggiero
leggy105210243legg__y
leghorns1244903leghorns
legion75712983le_gion
legist71315253le_gist
legists899593legists
legit61323503le_gi_t
legless838013legless
leglike12136843leglike
legman949653legman_
legmen939343legmen_
legong836963le_gong
legongs934543legongs
legs56133693le_g__s
legumes1036633legumes
legumin1045073legumin_
leis45739603le__i_s
lekking11306503lekking
lemans85316393le_mans
lemming12269393lemming
lemmings13254733lemmings
lemons84415053le_mons
lending94118533lending
lengths1144083lengths
lenis56326863le_ni_s
lens46146493le___ns
lensing84015103lensing
lentils73912973lentils
leonine7311233leonine
leptin82512333leptin_
leptons91910433leptons
lesbians1043603lesbians
lesions73813873lesions
lessens7409383lessens
lessons73811023lessons
letting83218533letting
leucin839113leucin_
leucine938073leucine
leucines1037273leucines
leukons1135753leukons
levies93919863le_vies
levin84816413le_vin_
levis85818553le_vi_s
levulins1144803levulins
levying1435873levying
lewis85315843le_wi_s
lexis125916033le_xi_s
lezzies1536203lezzies
ligans76817733l_igans
lignans8398853lignans
lignin74911193lignin_
ligroins946823ligroins
linins65922143l_inins
lins47059053l___ins
lipins85016883l_ipins
lodging103110813lodging
lodgings11336243lodgings
logans76319063l_ogans
loggats9286453loggats
loggers94616133loggers
loggets9378913loggets
loggia8457053loggi_a
loggie84011993loggi_e
loggier93811143loggier
loggiest103011013loggiest
loggish12258733loggish
logics95711123l_ogics
login66025003l_ogin_
logions86211293logions
logons79818173l_ogons
loins56728423l__oins
lomeins969483lomeins
longans84510813longans
longies82916553longies
longing93915783longing
longings10408563longings
lugeing9359113lugeing
luggers93713483luggers
luggie8318903luggi_e
luging83915293l_uging
lungans8399053lungans
lunging93714213lunging
lungis77113023lungi_s
lupins84514463l_upins
luteins7310103luteins
lysins94610953l_ysins
margins103815193margins
megrims1276103megrims
merging112711763merging
merlins93015813merlins
moggies113111723moggies
mogging123311493mogging
mugging122711793mugging
muggings13244593muggings
nagging102613043nagging
noggin8288883noggin_
nogging103612723nogging
noggings11285743noggings
olefins1037493ole_fins
oleins6313523ole__ins
origins8310463origins
pectins112315233pectins
peins76128063pe__ins
pekins121812233pe_kins
penguins1145383penguins
pepsins11310433pepsins
pidgins11259123pidgins
piggies113813483piggies
piggin103111093piggin_
pigging123614673pigging
pledging13276363pledging
plugging13306893plugging
pugging122912543pugging
raggies93214733raggies
ragging103516683ragging
reagin74915533reagin_
rebegins1136003rebegins
recoins94019243recoins
redfins1139923redfins
regain74517763regain_
reggaes948883reggaes
regina75317143re_gina
reginas85614063re_ginas
regions83613473regions
regius7311923re_gius
regrind938983regrind
regrinds1035533regrinds
reigns74811753reig_ns
reins56234563re__ins
rejoins143111383rejoins
remains94117913remains
renins64526453re_nins
rennins74013413rennins
repins84924313re_pins
requins16310203requins
resigns83910963resigns
resins64528773re_sins
retains74522253retains
rewins95020823re_wins
rigging103016333rigging
riggings11327133riggings
rugging102512763rugging
sagging103116103sagging
seggars9377783seggars
seisins73614393seisins
seizins164010133seizins
sequins1637863sequins
sereins73716123sereins
serging93416673serging
sergings10299213sergings
serins64029673se_rins
slagging113711583slagging
sledging11288183sledging
slogging113410493slogging
slugging11339423slugging
tagging103014913tagging
taleggios1151493taleggios
teggs74710743tegg__s
tegmina1035243tegmina
tenpins9410073tenpins
togging103512743togging
tugging102611233tugging
vegans103910853ve_gans
veggie1136303veggi_e
vegies104314273ve_gies
veins84620493ve__ins
venging123710943venging
venins93816703ve_nins
verdins112812333verdins
verging123812303verging
virgins1137863virgins
wagging133313353wagging
waggons1235503waggons
wedgies123910213wedgies
wedging13308723wedging
welkins1437173welkins
wigging133413833wigging
wiggings14316173wiggings
yeelins1038813yeelins
yeggs10608163yegg__s
yogins105114103_yogins
zagging193210453zagging
zeatins16311733zeatins
zechins21137123zechins
zeins144715393ze__ins
zigging193210533zigging

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 Limit1340273626.76619808.9
3Display Results3623620.1232943.1
 (SQL Overall)1786913627.29524495.0
 
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.