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

306 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
jaygee175946(None) 
jaygees1854511jaygees
jayvee1957611jayvee
agee56241492_a_gee
bargee94624442bargee
jaeger14397192jaeger
jager134318132ja_ger
jagged164115352jagged
jagger154016002jagger
jangle144416292jangle
jayvees2052922jayvees
payee105524722pay_ee
ragee65432662ra_gee
raggee84217602raggee
ackee115825373_ackee
age47154333_a_g_e
aged67334253_a_ged
agene65621583_a_gene
ager55935843_a_ger
ages55844593_a_ges
agger76420893_agger
aggie73415013_aggie
aglee65728493_aglee
agree65226033_agree
ague55725923_a_gue
ajee115928233_a_jee
akee85936813_a_kee
alee46652323_a_lee
algae65319623_algae
allee54932123_allee
angel65019563_angel
anger66225873_anger
angle64528873_angle
apogee9312563apogee
argle65421563_argle
argue64818443_argue
auger64922473_auger
awee76336643_a_wee
aye67151763_ay__e
ayes76543513_ay_es
badge94819693badg_e
badged114814793badged
badger105415083badger
badges103917373badges
bagel85116793ba_gel
bagged114519903bagged
bagger104619203bagger
baggie102912193baggie
bailee84526013bailee
banged104923723banged
banger94423633banger
bangle94018953bangle
barege94713543barege
barge85631023barg_e
barged105822643barged
bargees105415873bargees
barges94528253barges
baubee103215993baubee
bawbee132714233bawbee
bayed115423023bay_ed
baymen134212003baymen
bungee96319773bungee
burgee97120593burgee
cadge94018793cadg_e
cadged114812343cadged
cadger105013913cadger
cadges104716713cadges
cage75339063ca_g_e
caged95426363ca_ged
cager85229223ca_ger
cages85936013ca_ges
cagey115917823ca_gey
callee84327293callee
cangue91012443cangue
cayuse11207763cayuse
congee96024473congee
dagger95017303dagger
daggle93711903daggle
danged94819483danged
danger83722823danger
dangle84119303dangle
daybed13438673daybed
dragee84415603dragee
eager65526973ea_ger
eagle64219483ea_gle
eagre64315323ea_gre
fadge104817003fadg_e
fadged124712363fadged
fadges114814033fadges
fagged124717703fagged
fanged114318223fanged
fayed126422153fay_ed
gadget93616183gadget
gage65936103ga_g_e
gaged85522313ga_ged
gager74726293ga_ger
gages74529973ga_ges
gagged104817153gagged
gagger95016513gagger
gaggle93412623gaggle
ganged94619193ganged
ganger83721463ganger
gangue81310573gangue
garget84327273garget
gargle84215463gargle
gauge76117903gaug_e
gauged94713473gauged
gauger84714853gauger
gauges85915993gauges
gayer94519193gay_er
gee45359203___gee
hackee154921833hackee
hadjee174111823hadjee
hagged124317703hagged
haggle113511983haggle
hanged114222393hanged
hanger104023253hanger
hayed125822013hay_ed
hayer114620243hay_er
hayey144812533hay_ey
hayseed1435633hayseed
jabbed184213483jabbed
jabber173713643jabber
jacked204817523jacked
jacker194417583jacker
jacket194720673jacket
jade125325443ja__de
jaded144417033ja_ded
jades135222113ja_des
jaegers15307103jaegers
jag116542713ja_g__
jagers144415723ja_gers
jagg136115313ja_g_g
jaggeder1842783jaggeder
jaggers164012893jaggers
jaggery19336903jaggery
jaggier16339183jaggier
jaggies163311083jaggies
jaggs148111493ja_ggs
jaggy175913143ja_ggy
jagra1338173ja_gra
jags126132793ja_g_s
jailed144917423jailed
jailer134316683jailer
jake155925773ja__ke
jakes165023643ja_kes
jambe165314753ja_mbe
jambed184811403jambed
jambes175914053jambes
jammed183811503jammed
jammer174014133jammer
jane115031483ja__ne
janes124928123ja_nes
jangled164111563jangled
jangler153811833jangler
jangles154015683jangles
jangly174310603jangly
jape134923423ja__pe
japed156217633ja_ped
japer146218883ja_per
japes146322823ja_pes
jargon1448823jargon
jarred144613253jarred
jarvey19135403jarvey
jasper154610383jasper
jauked18489013jauked
jaunce15367433jaunce
jauped16457903jauped
jawed165517373ja_wed
jay136242673jay___
jays146328343jay__s
jazzed22416293jazzed
jazzer21376503jazzer
jazzes21347883jazzes
jee106648643j___ee
jigged164412773jigged
jigger155313053jigger
jiggle153811993jiggle
jingle143815223jingle
jinnee13411573jinnee
jogged166015923jogged
jogger154713163jogger
joggle154010353joggle
joyed164811833joy_ed
judge144714163judg_e
judged165911263judged
judger154411453judger
judges153713463judges
jugged163813933jugged
juggle154310283juggle
jungle144012653jungle
kayles134712003kayles
kayoed14416903kayoed
kayoes134710823kayoes
laager74312783laager
lager65132863la_ger
lagged95520133lagged
lagger85919833lagger
langue71012173langue
laree56036293la_ree
large65325463larg_e
larger74417513larger
larges74824233larges
layed95127383lay_ed
layer84626473lay_er
laymen113010843laymen
lungee75119813lungee
lycee104716743_lycee
mage75739133ma_g_e
mages85036023ma_ges
maigre9309163maigre
malgre9299303malgre
mallee84525593mallee
mammee94417853mammee
manege94113203manege
mange84930193mang_e
mangel94017533mangel
manger94325003manger
manges94628943manges
mangey123614523mangey
mangle93921323mangle
marge85328333marg_e
marges94525713marges
mauger93813483mauger
maugre9308973maugre
maybe12311133may_be
maybes1339243maybes
mayed115522403may_ed
mayhem1644923mayhem
mayweed1634163mayweed
mergee94018143mergee
muggee103612833muggee
nagged93916053nagged
nagger84016123nagger
ogee57629883__ogee
oxygen1743313oxygen
page76036103pa_g_e
paged95926783pa_ged
pager84728203pa_ger
pages85235073pa_ges
panged104722333panged
pangen94115913pangen
pangene102711963pangene
pardee93922023pardee
parge85831853parg_e
parged104922043parged
parges94529543parges
parget94529393parget
passee84522023passee
pattee84323383pattee
pawnee113115403pawnee
payed115925933pay_ed
payees114812903payees
payer105125723pay_er
pongee94920193pongee
rage55742353ra_g_e
raged74829453ra_ged
ragees74618663ra_gees
rages64539443ra_ges
ragged94620263ragged
raggees93710913raggees
raggle83712883raggle
rakee96031173ra_kee
ramee74633853ra_mee
ranee55438103ra_nee
range64728413rang_e
ranged84824313ranged
ranger73925523ranger
ranges73826923ranges
rappee103618673rappee
rayed95127503ray_ed
razee145827803ra_zee
sage55044593sa_g_e
sager65432053sa_ger
sages65339063sa_ges
sagged94120013sagged
sagger84321073sagger
sanger74524563sanger
saree55044663sa_ree
sarge65531133sarg_e
sarges75128593sarges
sauger74316253sauger
sayed96127143say_ed
sayer84926553say_er
sycee105018623_sycee
tagged93418123tagged
tagger84017703tagger
tanged84622493tanged
tangle74019953tangle
targe65227093targ_e
targes74524593targes
target75028903target
tyee75131423_ty_ee
vague96513113va_gue
wage84834083wa_g_e
waged104822783wa_ged
wager95925053wa_ger
wages95330933wa_ges
wagged124616123wagged
wagger113616013wagger
waggle113612303waggle
wangle103817503wangle
whangee14268613whangee
yager95616753ya_ger
yogee9518063_yogee
zagged183612513zagged

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127163064.97022679.3
3Display Results3063060.0933290.3
 (SQL Overall)1786913065.43632871.8
 
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.