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

395 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
leggier936823(None) 
ledgier9458491ledgier
leggiero10342761leggiero
loggier93811141loggier
baggier113611642baggier
boggier113711582boggier
buggier113611342buggier
cloggier1244252cloggier
doggier103810942doggier
dreggier1193552dreggier
edgier8469722_edgier
egger74414402_egg_er
faggier12309842faggier
flaggier13105202flaggier
fledgier1333682fledgier
foggier12349912foggier
fuggier12348962fuggier
hedgier12367872hedgier
jaggier16339182jaggier
jiggier16377822jiggier
kegger12388062kegg_er
lagger85919832lagg_er
leadier83212722leadier
leafier10329832leafier
leaguer835792leaguer
leakier114010992leakier
learier73415662learier
leavier10319992leavier
ledger85914362ledg_er
leerier73111502leerier
leger65721502le_g_er
legged95713082legg_ed
leggiest10308232leggiest
leggin8268592leggi_n
legging103912642legging
leggins9259472leggins
levier94013872le_vier
lingier84113382lingier
logger86420002logg_er
loggie84011992loggie_
logier75015732l_ogier
lugger83916552lugg_er
luggie8318902luggie_
luggies93011212luggies
muggier11288942muggier
naggier9309152naggier
piggier113510002piggier
puggier11309382puggier
saggier92912062saggier
sedgier9399042sedgier
slaggier10126952slaggier
soggier93410882soggier
veggie1136302veggie_
veggies1237552veggies
vuggier12296812vuggier
wedgier12428272wedgier
wiggier12418862wiggier
aerier64823153ae_rier
agger76420893_agg_er
aggie73415013_aggie_
aggies83515513_aggies
angrier839023angrier
bagger104619203bagg_er
baggie102912193baggie_
baggies113814853baggies
beadier103513913beadier
beakier134012163beakier
beamier113411943beamier
beefier12329093beefier
beerier93613023beerier
beggar10328223begg_ar
begged115013803begg_ed
begging123012653begging
beguiler1154063beguiler
belier84423563be_lier
bendier103111413bendier
bigger104315063bigg_er
biggie103810933biggie_
biggies113813523biggies
bilgier10358533bilgier
blearier1037333blearier
blogger11448313blogg_er
boggler113910083boggler
braggier12136453braggier
bugger104418723bugg_er
buggies114613813buggies
bulgier103911213bulgier
cagier93715933_cagier
clergies1137903clergies
clingier1155853clingier
clogger11438803clogg_er
craggier12116063craggier
dagger95017303dagg_er
decrier102713553decrier
deedier93011593deedier
defier105118653de_fier
deifier113013123deifier
denier74420693de_nier
dernier83011943dernier
dewier104013463de_wier
digger94616083digg_er
dingier93513673dingier
dodgier10388243dodgier
dogger95216783dogg_er
doggie93910893doggie_
doggies103613023doggies
draggier11135773draggier
druggier11134833druggier
dungier9368583dungier
eager65526963_eag_er
easier64218463_easier
edger75215933_edg_er
eelier64216463_eelier
eerier64320023_eerier
eger55923563_e_g_er
eggar7458883_egg_ar
egged85114383_egg_ed
eggers84612583_egg_ers
egging93210983_egging
elegies81312903elegies
elmier839813_elmier
envier939673_envier
feigner1135593feigner
fennier10339253fennier
fernier103110813fernier
flagger12469353flagg_er
fleecier1334763fleecier
fleshier1435603fleshier
flogger12449463flogg_er
fogger114414783fogg_er
froggier1354643froggier
gagger95016513gagg_er
geekier12286393geekier
gemmier12337383gemmier
germier10309543germier
giggler101029883giggler
gigglier1154323gigglier
gleamier1144913gleamier
gleetier934913gleetier
goggler10379323goggler
gogglier1153923gogglier
groggier1134343groggier
haggler12328933haggler
headier113212953headier
heavier13429423heavier
hedger114912633hedg_er
heftier1337203heftier
hempier14319003hempier
herbier1239593herbier
higgler12369803higgler
hogger114615083hogg_er
hugger114713123hugg_er
jagger154016003jagg_er
jaggies163311083jaggies
jerkier18407273jerkier
jettier14358693jettier
jigger155313053jigg_er
jigglier1754093jigglier
jogger154713163jogg_er
joggler16398833joggler
juggler16418873juggler
kegeler1245493kegeler
kegged13469243kegg_ed
keggers13357033kegg_ers
kegging14328293kegging
kegler11398233ke_gler
kludgier1432463kludgier
laager74312783laag_er
lacier84020093l_acier
lager65132863l_ag_er
lagged95520133lagg_ed
laggers94216243lagg_ers
lagging103316733lagging
lakier104716273l_akier
lambier113611643lambier
lankier113711633lankier
lardier83518343lardier
larger74417513larg_er
larkier113711523larkier
lathier10310833lathier
laugher1136603laugher
lawgiver1541943lawgiver
lazier154214613l_azier
leacher124014843leacher
leachier1337253leachier
leader74824653le_ader
league758743league_
leagued935463leagued
leaguers935063leaguers
leagues837943leagues
leaker104620073le_aker
leaner64022193le_aner
leaper88118943le_aper
learner7319383learner
leaser65322673le_aser
leather103815783leather
leaver94321513le_aver
lecher113415853le_cher
ledge76519463ledg_e_
ledgers94912173ledg_ers
ledges84917983ledg_es
ledgiest10288593ledgiest
leer46239353le___er
lefter93613433le_fter
lefties10312073lefties
legacies1139043legacies
legalizer1946323legalizer
legate72917453legate_
legated92513983legated
legatee82814633legatee
legates82917673legates
legator83011133legator
legers74518313le_g_ers
leges64427283le_g_es
legginess1135033legginess
leggings11316193leggings
leggy105210243legg__y
legion75712983le_gion
legist71315253le_gist
legit61323503le_gi_t
legits71313003le_gits
leglike12136843leglike
legmen939343le_gmen
legume936913legume_
legumes1036633legumes
leister73212753leister
lender73921273le_nder
lengthier1342413lengthier
leper74820743le__per
lesser63514853le_sser
letter63722583le_tter
leveler10399903leveler
lever85125163le__ver
levied104111433le_vied
leviers103510343le_viers
levies93919863le_vies
lewder10479613le_wder
lezzie1435333lezzie_
lezzies1536203lezzies
lier45942463l___ier
liger65024473l_ig_er
lighter113113433lighter
limbier11349113limbier
limier83518723l_imier
linger75226003ling_er
linier64423793l_inier
lintier73613803lintier
lippier112710573lippier
livier97514593l_ivier
loamier9349163loamier
lodger86517683lodg_er
loftier1037763loftier
logged96622943logg_ed
loggers94616133logg_ers
loggia8457053loggi_a
loggias9356783loggias
loggiest103011013loggiest
logging103316803logging
loggish12258723loggish
longer75823203long_er
longies82916553longies
loonier73312683loonier
loopier93711193loopier
loppier11369723loppier
lousier72411623lousier
lowlier10338903lowlier
luckier133811533luckier
luger65322083l_ug_er
lugged94417053lugg_ed
luggers93713483lugg_ers
lugging104114353lugging
lumpier113410143lumpier
lunger75720423lung_er
lunier64617603l_unier
lustier73813503lustier
luthier1038233luthier
mangier104114063mangier
meager94515193meag_er
mealier93015903mealier
meatier93214613meatier
merger95016473merg_er
merrier92612303merrier
meshier123410853meshier
messier93412923messier
metier83517693me_tier
mingier103815293mingier
moggie103210103moggie_
moggies113111723moggies
mugger103914703mugg_er
nagger84016123nagg_er
needier84010623needier
negater83711953negater
nerdier83110353nerdier
nervier10298833nervier
nettier74211813nettier
newsier10147223newsier
nigger89713573nigg_er
niggler93610293niggler
nigglier1044843nigglier
peakier134411443peakier
peatier94017233peatier
peckier153910523peckier
pegged114811903pegg_ed
pegging122811133pegging
peppier10268323peppier
perkier133813123perkier
peskier13319113peskier
pestier94317403pestier
pettier94213613pettier
phlegmier1741173phlegmier
piggie103210773piggie_
piggies113813483piggies
pledger11359153pledg_er
plugger11378423plugg_er
podgier11338723podgier
pudgier11377723pudgier
quaggier1933853quaggier
raggies93214733raggies
rangier83714353rangier
readier83117423readier
reedier83815303reedier
reefier102912553reefier
reekier113111123reekier
regainer9249353regainer
regaler83814623regaler
reggae858953reggae_
reggaes948883reggaes
reifier103414523reifier
relier65826183re_lier
rentier73618223rentier
replier94214973replier
ridgier937883ridgier
rigger85616713rigg_er
rugger84414513rugg_er
sagger84321073sagg_er
sagier73717163_sagier
seamier93114633seamier
seedier83513633seedier
seepier92912013seepier
seggar8357813segg_ar
serger73819733serg_er
sexier13310683se_xier
shaggier13116053shaggier
slangier9117933slangier
sleazier1735123sleazier
sleekier1245573sleekier
sleepier1036783sleepier
sleetier837883sleetier
sleigher1234313sleigher
slogger94310483slogg_er
sludgier1034823sludgier
slugger93610673slugg_er
smoggier1243973smoggier
snaggier10136303snaggier
staggier10167513staggier
stagier83513443stagier
tagger84017703tagg_er
tangier83013903tangier
tearier73815613tearier
techier1269243techier
teenier72611143teenier
tentier73815923tentier
terrier73414963terrier
testier74015643testier
toggler9399193toggler
tugger84013103tugg_er
twiggier1333073twiggier
uglier748953_uglier
vealier102712173vealier
vegged124910013vegg_ed
vegging13308873vegging
vegie94614513ve_gie_
vegies104314273ve_gies
veinier10269583veinier
veliger1137313veliger
verger104315693verg_er
verier94620963ve_rier
vernier102711273vernier
wagger113616013wagg_er
wagglier1344323wagglier
wearier103613283wearier
webbier1445423webbier
wedgie11428353wedgie_
wedgies123910203wedgies
weedier113810623weedier
weenier103210803weenier
weepier12319273weepier
weigher14136343weigher
wennier10318603wennier
wiggler123110763wiggler
wigglier1354453wigglier
wingier113413283wingier
yeggmen1442673yeggmen
zestier163010223zestier
zingier17369493zingier

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.190940478.9
2DLD Change Limit1340273957.32618294.7
3Display Results3953950.1402821.4
 (SQL Overall)1786913957.65623340.0
 
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.