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

249 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
grantees9251097(None) 
grandees103211281grandees
grantee83217131grantee_
granters93614141granters
draftees12225252draftees
giantess933892giantess
goatees82710442goa_tees
grafters12409192grafters
grandee93115512grandee_
grangers103011972grangers
granges93516522gran_ges
granites92116362granites
grannies9312612grannies
granted94715102grant_ed
granter84117132grant_er
grantors93810362grantors
grants73722472grant__s
granules939932granules
graters85419742gra_ters
grates75429892gra_t_es
grunters9359032grunters
gruntles9287232gruntles
guarantees1142622guarantees
ranees64623962_ran_ees
ranters73323642_ranters
anteed75616113__anteed
antes56334323__ant_es
antres65021003__antres
banters94623113_banters
banties94324763_banties
branches153613803branches
branders114313093branders
brandies11714563brandies
branners104010923branners
brants85723053brant__s
brattles10199333brattles
canteen9411083_canteen
canteens1038573_canteens
canters94827733_canters
cantles94721413_cantles
chanters134016743chanters
chanteys16387493chanteys
chanties132615803chanties
coatees93816553coa_tees
corantoes1147653corantoes
crafters13419953crafters
cranches153114543cranches
cranes84330753cran__es
crankles143510153crankles
crannies10313013crannies
craters95021893cra_ters
crates85736063cra_t_es
draftee11379523draftee_
drafters12338533drafters
dragees9359483dra_gees
drawees11378363dra_wees
fiancees1335103fiancees
frankers15348353frankers
fraters103517213fra_ters
frontes104214163front_es
gaiters83516543g_aiters
gametes10312253g_ametes
ganders93521703g_anders
ganefs10489203g_an_efs
ganevs10456913g_an_evs
gangers94418603g_angers
gangues9149753g_angues
gannets83811443g_annets
gantlet83616243g_antlet
gantlets9308903g_antlets
gantries91413793g_antries
garners83815983garn_ers
garnets84115403garn_ets
garotes8614563garot_es
garottes978283garottes
garters84218233g_arters
gasters85624293g_asters
gaters74728643g_a_ters
gates65939513g_a_t_es
genteel836753g_enteel
gentes75324163g_ent_es
gentles83714343g_entles
giantesses1143513giantesses
giants74713503giant__s
giftees11306513g_iftees
glancers11408003glancers
glances104113143glan_ces
glanders103811503glanders
glandes95413833glan_des
goatee73219533goa_tee_
goateed9307063goa_teed
grabbers13337883grabbers
grabbles13339893grabbles
grabens10367003gra_bens
graces94523493gra__ces
graciles112511613graciles
grackles15309183grackles
gradates10510783gradates
graders94716013gra_ders
grades84926313gra__des
gradines103615253gradines
graduses1046453graduses
graftages1443683graftages
grafted124110223graft_ed
grafter114211153graft_er
grafts105013253graft__s
grainers93012073grainers
grainless1035893grainless
grammes123611323gra_mmes
granaries10159883granaries
grandads1136553grandads
grandames1346713grandames
grandams1237123grandams
grander93315873gran_der
grandest10311573grandest
grandeur10305673grandeur
grandeurs11335113grandeurs
grandmas1236923grandmas
grandness1138303grandness
grandpas1236003grandpas
grands84218243gran__ds
grange83716203gran_ge_
granger93514213gran_ger
granitas92610223granitas
granite82017083granite_
grannie8310353grannie_
granolas938053granolas
grans64832543gran___s
grant64840023grant___
granting103514523granting
grantor84010943grant_or
grantsmen1294643grantsmen
granule839473granule_
grapes95123123gra__pes
graphemes1743633graphemes
grapnels1134393grapnels
grapples13348123grapples
graspers11338403graspers
grasses84117343gra_sses
grate64932883gra_t_e_
grated84523923gra_t_ed
grateless10277583gra_teless
grater74625443gra_t_er
gratinees10307323gratinees
gratins84119183gra_tins
gratis74819243gra_t_is
graupels1133103graupels
gravels113611143gra_vels
gravers114515273gra_vers
graves104624003gra__ves
gravies11314093gra_vies
gravities1338303gravities
gravures1234903gravures
grayness1235933grayness
grazers175112453gra_zers
grazes164519643gra__zes
graziers18387123graziers
greatens9307593greatens
greatness1036903greatness
grees65132473gr___ees
greeters92610113greeters
grenades1038433grenades
grifters12389233grifters
grinches1436953grinches
grinders103410423grinders
grinners9288043grinners
gristers94013403gristers
gristles9189203gristles
gritters94210633gritters
groaners9248503groan_ers
grottoes9276753grottoes
grouters95910083grouters
grungers10298503grungers
grunges93310403grun_ges
grunted9339283grunt_ed
grunter83110783grunt_er
gruntle8257053gruntle_
gruntled10274943gruntled
grunts75511853grunt__s
guanases936233guanases
guanines989773guanines
guarantee1044673guarantee_
guaranteed1251733guaranteed
guaranties1144383guaranties
gyrates113610263gyra_t_es
hantles104117513_hantles
kanteles1238123_kanteles
kraters114212343kra_ters
manatees10310423_manatees
mantels94515043_mantels
mantes84430783_mant_es
mantles94820703_mantles
mentees93214503_mentees
oranges84215333oran_ges
orates64328613ora_t_es
panties94230933_panties
planters102915323planters
prancers123210333prancers
prances113618773pran_ces
praters94921653pra_ters
prates84633163pra_t_es
prattles10189403prattles
printers103214903printers
rafters103715633_rafters
ragees74618663_ra_gees
raggees93710913_raggees
rakees104516973_ra_kees
ramees84620893_ra_mees
rances84625443_ran_ces
ranches123620113_ranches
randies84225663_randies
ranee55438103_ran_ee_
rangers83621043_rangers
ranges73826923_ran_ges
rankers113217463_rankers
rankles113114543_rankles
ranted74324703_rant_ed
ranter63826823_rant_er
rants55935343_rant__s
rappees113611453_rappees
rasters74629023_rasters
ratels64518213_ra_tels
raters63936583_ra_ters
rates55352013_ra_t_es
ratteen7329113_ratteen
ratteens8256053_ratteens
rattens74213403_rattens
ratters74422473_ratters
rattles73217303_rattles
razees154314763_ra_zees
renters74224813_renters
rentes65431193_rent_es
scanties103215423scanties
shanteys14395513shanteys
shanties113116593shanties
standees93310143standees
trainees82712063trainees
trances93919643tran_ces
tranches132915513tranches
trannies8415013trannies
trustees8339323trustees
uranides92211283uranides
uranites82514643uranites
urates65027763ura_t_es
wanters104420093_wanters
warrantees1343443warrantees
whangees15275063whangees
wrangles1237463wrangles
wrastles11328933wrastles

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622497.00020880.3
3Display Results2492490.0962593.8
 (SQL Overall)1786912497.50223819.1
 
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.