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

216 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
jaygees185451(None) 
jaygee1759461jaygee_
jayvees2052921jayvees
bargees105415872bargees
jaegers15307102jaegers
jagers144415722ja_gers
jaggers164012892jaggers
jaggies163311082jaggies
jangles154015682jangles
jayvee1957612jayvee_
payees114812902pay_ees
ragees74618662ra_gees
raggees93710912raggees
ackees124914583_ackees
agee56241493_a_gee_
agenes74720253_a_genes
agers65027853_a_gers
ages55844593_a_g_es
aggers85817793_aggers
aggies83515513_aggies
agrees74915323_agrees
agues64919053_a_gues
akees96119243_a_kees
allees64521483_allees
angels74416173_angels
angers75222543_angers
angles74426703_angles
apogees1037103apogees
argles75218483_argles
argues74516413_argues
augers73818703_augers
ayes76543513_ay__es
badgers114812653badgers
badges103917373badg_es
bagels95712313ba_gels
baggers113915693baggers
baggies113814853baggies
bailees93914383bailees
bangers104020353bangers
bangles103617413bangles
bareges105212033bareges
bargee94624443bargee_
barges94528253barg_es
baubees11348713baubees
bawbees14337243bawbees
bungees104513103bungees
burgees104915893burgees
cadgers114712003cadgers
cadges104716713cadg_es
cagers95624193ca_gers
cages85936013ca_g_es
callees94117783callees
cangues10611823cangues
cargoes104415223cargoes
cayuses12188403cayuses
congees103517923congees
daggers103714913daggers
daggles103611913daggles
dagoes85714603da_goes
dangers94818213dangers
dangles93618423dangles
daybeds14234473daybeds
dragees9359483dragees
eagers74523683ea_gers
eagles73819163ea_gles
eagres74014573ea_gres
fadges114814033fadg_es
gadgets10348683gadgets
gagers84021333ga_gers
gages74529973ga_g_es
gaggers103413663gaggers
gaggles103512593gaggles
gangers94418603gangers
gangues9149753gangues
gargets94614573gargets
gargles94214893gargles
gaugers94211713gaugers
gauges85915993gaug_es
gayness1136843gayness
gees55647883___gees
hackees165014103hackees
hadjees18356383hadjees
haggles123312483haggles
hangers113120813hangers
hayers124415943hay_ers
hayseed1435633hayseed
hayseeds1543283hayseeds
jabbers183610583jabbers
jacales16310323jacales
jackers204214453jackers
jackets205011373jackets
jackies202912623jackies
jades135222113ja__des
jaeger14397193jaeg_er
jager134318133ja_g_er
jagged164115353ja_gged
jaggeder1842783jaggeder
jaggedest1942853jaggedest
jagger154016003ja_gger
jaggeries18136973jaggeries
jaggery19336903jaggery
jaggier16339183jaggier
jaggiest17289323jaggiest
jaggs148111493ja_g_gs
jagless1537103jagless
jagras1438463ja_gras
jags126132793ja_g__s
jailers144114043jailers
jakes165023643ja__kes
jambes175914053ja_mbes
jammers183710703jammers
jammies183611293jammies
janes124928123ja__nes
jangle144416303jangle_
jangled164111563jangled
jangler153811833jangler
janglers16319373janglers
japers154616173ja_pers
japes146322823ja__pes
jargons1558203jargons
jarveys20123413jarveys
jaspers164310463jaspers
jaunces16307423jaunces
jawless1745653jawless
jays146328343jay___s
jazzers22324763jazzers
jazzes21347883ja_zzes
jees115938543j___ees
jiggers164010183jiggers
jiggles164111433jiggles
jingles153816383jingles
jingoes153811443jingoes
joggers164110693joggers
joggles164410413joggles
joyless17226513joyless
judgers16369043judgers
judges153713463judg_es
juggles164510843juggles
jungles154112543jungles
kayles134712003kay_les
kayoes134710823kay_oes
laagers83411253laagers
lagers74826143la_gers
laggers94216243laggers
langues81211913langues
larees65323113la_rees
larges74824233larg_es
largess8408913largess
layers93921183lay_ers
lungees84412143lungees
lycees11428863_lycees
mages85036023ma_g_es
mallees93315973mallees
mammees104411143mammees
maneges103612143maneges
mangels103614493mangels
mangers103521263mangers
manges94628953mang_es
mangles104021463mangles
mangoes104316133mangoes
marges94525713marg_es
maybes1339243may_bes
mayhems1763413mayhems
mayweed1634163mayweed
mayweeds1742993mayweeds
mergees104411233mergees
muggees11338883muggees
naggers93812653naggers
ogees65119143__ogees
oxygens1843163oxygens
pagers94423253pa_gers
pages85235073pa_g_es
pangenes112612823pangenes
pangens103112063pangens
parges94529543parg_es
pargets105215193pargets
pawnees12298173pawnees
payee105524723pay_ee_
payers114621823pay_ers
pongees104212543pongees
ragee65432663ra_gee_
rages64539443ra_g_es
raggee84217603raggee_
raggies93214733raggies
raggles93813283raggles
rakees104516973ra_kees
ramees84620893ra_mees
ranees64623963ra_nees
rangers83621043rangers
ranges73826933rang_es
rappees113611453rappees
rayless10239003rayless
razees154314763ra_zees
sages65339063sa_g_es
saggers94017083saggers
sangers84421943sangers
sarees65329943sa_rees
sarges75128593sarg_es
saugers83914053saugers
sayeds10469253say_eds
sayers94221593say_ers
sycees11409653_sycees
taggers93514193taggers
tangles83920053tangles
targes74524603targ_es
targets84314223targets
tyees86019453_ty_ees
wagers105122203wa_gers
wages95330933wa_g_es
waggers124613083waggers
waggles123812003waggles
wangles113416933wangles
wayless13308243wayless
whangees15275063whangees
yagers105114533ya_gers
yogees10510633_yogees

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 Limit1340272167.22018563.3
3Display Results2162160.0603600.0
 (SQL Overall)1786912167.68623248.9
 
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.