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

282 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
jaggery1933690(None) 
jaggary19304861jaggary
jagger154016001jagger_
jaggers164012891jaggers
jagghery2351801jagghery
waggery15276901waggery
agger76420892_agger_
aggers85817792_aggers
bagger104619202bagger_
baggers113915692baggers
buggery14367932buggery
dagger95017302dagger_
daggers103714912daggers
doggery13448262doggery
gagger95016512gagger_
gaggers103413662gaggers
jaeger14397192jaeger_
jaegers15307102jaegers
jager134318132ja_ger_
jagers144415722ja_gers
jagged164115352jagge_d
jaggedly21222942jaggedly
jaggier16339182jaggier_
jaggy175913142jagg__y
japery18439142ja_pery
jaspery19405252jaspery
jigger155313052jigger_
jiggers164010172jiggers
jogger154713162jogger_
joggers164110692joggers
jugglery20303812jugglery
lagger85919832lagger_
laggers94216242laggers
nagger84016122nagger_
naggers93812652naggers
piggery14266192piggery
raggedy13334662raggedy
sagger84321072sagger_
saggers94017082saggers
staggery13346242staggery
tagger84017702tagger_
taggers93514192taggers
toggery12505922toggery
wagger113616012wagger_
waggers124613082waggers
wiggery15295872wiggery
aery77231683_a__ery
ager55935843_a_ger_
agers65027853_a_gers
aggro738003_agg_ro
agley96917333_agle_y
ambery133811133_ambery
angary10311323_angary
anger66225873_anger_
angerly1137773_angerly
angers75222543_angers
angry9310863_ang_ry
apery106517903_a_pery
artery9911453_artery
auger64922473_auger_
augers73818703_augers
augury10366663_augury
badger105415073badger_
badgerly1543283badgerly
badgers114812643badgers
bagged114519903bagge_d
baggier113611643baggier_
baggily1436043baggily
baggy125615683bagg__y
bakery155911003ba_kery
banger94423633banger_
bangers104020353bangers
battery124911813battery
beggary14316153beggary
bigger104315063bigger_
biggety1434433biggety
bragger113810043bragger_
braggers12327903braggers
bugger104418723bugger_
buggers114315663buggers
cadger105013893cadger_
cadgers114711993cadgers
cager85229223ca_ger_
cagers95624183ca_gers
cagey115917823ca_ge_y
cagier93715933cagier_
cannery123610013cannery
cattery123811603cattery
cautery12349573cautery
daggered12246403daggered
danger83722823danger_
dangers94818213dangers
daubery13396213daubery
digger94616083digger_
diggers104413383diggers
dodgery13627783dodgery
dogger95216783dogger_
doggers104413433doggers
dragger10309173dragger_
draggers11357393draggers
eager65526963ea_ger_
eagerly1136053ea_gerly
eagers74523683ea_gers
eatery95316353ea_tery
egger74414403_egger_
eggers84612583_eggers
faery116015483fa__ery
fagged124717703fagge_d
faggier12309843faggier_
faggotry1641673faggotry
faggoty1542853faggoty
faggy136514373fagg__y
fakery16509263fa_kery
flagger12469353flagger_
flaggers13328073flaggers
fogger114414783fogger_
foggers124112013foggers
forgery14419303forgery
gadgetry14263203gadgetry
gadgety13356163gadgety
gager74726293ga_ger_
gagers84021323ga_gers
gagged104817153gagge_d
gallery11468743gallery
ganger83721463ganger_
gangers94418603gangers
gargety12388043gargety
gaudery1234743gaudery
gauger84714853gauger_
gaugers94211703gaugers
gingery12368903gingery
groggery1433513groggery
hagberry1742903hagberry
haggard13377183haggard
hagged124317703hagge_d
haggler12328933haggler_
hagglers13326623hagglers
hanger104023253hanger_
hangers113120813hangers
hogger114615083hogger_
hoggers124512483hoggers
hugger114713123hugger_
huggers124211593huggers
imagery13124203imagery
jabber173713643jabber_
jabbers183610583jabbers
jacker194417583jacker_
jackers204214453jackers
jagg136115313jagg___
jaggeder1842783jaggeder
jaggeries18136973jaggeries
jaggies163311083jaggies
jaggiest17289323jaggiest
jagging173311993jagging
jaggs148111493jagg__s
jagless1537103jagless
jagra1338173ja_g_ra
jaguar1435283jaguar_
jaguars1535223jaguars
jailer134316683jailer_
jailers144114043jailers
jammer174014133jammer_
jammers183710703jammers
jangler153811833jangler_
janglers16319373janglers
jangly174310603jang_ly
japer146218883ja_per_
japers154616173ja_pers
jargony1834493jargony
jarvey19135403jarve_y
jasper154610383jasper_
jaspers164310463jaspers
jaygee1759463jayge_e
jaygees1854513jaygees
jazzer21376503jazzer_
jazzers22324763jazzers
jigged164412773jigge_d
jiggered1834203jiggered
jiggier16377823jiggier_
jiggly18378713jigg_ly
jiggy17549143jigg__y
jittery17346443jittery
jobbery21366013jobbery
jogged166015923jogge_d
joggler16398833joggler_
jogglers17356883jogglers
joinery17366593joinery
judger154411443judger_
judgers16369043judgers
jugged163813933jugge_d
juggler16418873juggler_
jugglers17366523jugglers
kegger12388063kegger_
keggers13357033keggers
laager74312783laager_
laagers83411253laagers
lager65132863la_ger_
lagers74826143la_gers
laggard10347623laggard
lagged95520133lagge_d
largely1136703largely
larger74417513larger_
lathery133911123lathery
logger86420003logger_
loggers94616133loggers
lugger83916553lugger_
luggers93713483luggers
maggoty1444003maggoty
maguey1236833mague_y
manger94325003manger_
mangers103521263mangers
mangey123614523mange_y
mastery124214323mastery
mattery123810713mattery
mauger93813483mauger_
mugger103914703mugger_
muggers113611933muggers
nagged93916053nagge_d
naggier9309153naggier_
naggy106612823nagg__y
napery11489813na_pery
nigger89713573nigger_
niggers93111313niggers
nuggety1234313nuggety
orangery12305543orangery
pager84728203pa_ger_
pagers94423253pa_gers
papery134812743pa_pery
priggery1543993priggery
puggry13374823pugg_ry
ragged94620263ragge_d
raggedly14284303raggedly
raggee84217603ragge_e
raggees93710913raggees
raggy106116573ragg__y
ranger73925523ranger_
rangers83621043rangers
rigger85616713rigger_
riggers93613833riggers
roguery1134893roguery
rugger84414513rugger_
ruggers94612313ruggers
sagely102811383sa_gely
sager65432053sa_ger_
saggar84010853saggar_
saggard10358953saggard
saggars93610683saggars
sagged94120003sagge_d
saggered11237553saggered
saggier92912063saggier_
saggy105917463sagg__y
sagier73717163sagier_
sanger74524563sanger_
sangers84421943sangers
sauger74316253sauger_
saugers83914053saugers
savagery1543223savagery
snuggery13253973snuggery
stagger94212393stagger_
staggers10379843staggers
surgery11319203surgery
swagger12389333swagger_
swaggers13407223swaggers
tagged93418123tagge_d
tannery10388663tannery
thuggery1642563thuggery
tugger84013103tugger_
tuggers93711443tuggers
vagary1337333va_gary
vaguely1443693vaguely
vaguer10448443vaguer_
wafery15398693wa_fery
wager95925053wa_ger_
wagers105122203wa_gers
wagged124616123wagge_d
waggly14347293wagg_ly
wastery134610993wastery
watery123914493wa_tery
wavery154610053wa_very
yager95616753ya_ger_
yagers105114533ya_gers
zagged183612513zagge_d

Search took 7 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.1531167915.0
2DLD Change Limit1340272826.42320866.7
3Display Results2822820.1102563.6
 (SQL Overall)1786912826.68626726.1
 
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.