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

347 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
grantee8321713(None) 
grandee93115511grandee
granted94715101granted
grantees92510971grantees
granter84117131granter
draftee11379522draftee
goatee73219532goa_tee
grafted124110222grafted
grafter114211152grafter
grandees103211282grandees
grander93315872grander
grange83716202gran_ge
granger93514212granger
granges93516522granges
granite82017082granite
granites92116362granites
grannie8310352grannie
grant64840022grant__
granters93614152granters
grantor84010942grantor
grants73722472grant_s
granule839472granule
grate64932882gra_t_e
grated84523922gra_ted
grater74625442gra_ter
grates75429892gra_tes
grunted9339282grunted
grunter83110782grunter
gruntle8257052gruntle
guarantee1044672guarantee
ranee55438102_ran_ee
ranted74324702_ranted
ranter63826822_ranter
antae56828293__antae
ante46538903__ant_e
anted66328243__anted
anteed75616113__anteed
antes56334323__antes
antre55224523__antre
banter84825343_banter
bracted12410933bracted
branded114414103branded
brander103915823brander
branned104311693branned
branner94212373branner
brant74742173brant__
brants85723053brant_s
brattle9249253brattle
canted94825783_canted
canteen9411083_canteen
canter85230113_canter
cantle84522153_cantle
chanted134015953chanted
chanter123919733chanter
chantey154112543chantey
coatee84327223coa_tee
crafted13419773crafted
crafter124111333crafter
crane75331603cran__e
craned96121653cran_ed
cranes84330753cran_es
cranked143812843cranked
cranker133612793cranker
crankle133610063crankle
crate76537403cra_t_e
crated94827773cra_ted
crater85026643cra_ter
crates85736063cra_tes
drafted12439033drafted
draftees12225253draftees
drafter11449433drafter
dragee84415603dra_gee
dratted9358593dratted
drawee104413823dra_wee
fiancee1238953fiancee
fracted1339373fracted
franked153610053franked
franker143510183franker
frantic12310373frantic
frater94520593fra_ter
fronted114011273fronted
fronter103611583fronter
frontes104214163frontes
gaited84416923g_aited
gaiter73819503g_aiter
gamete9313593g_amete
gander84322763g_ander
gane55145303g_an__e
ganef96322463g_an_ef
ganev95513863g_an_ev
ganged94619203g_anged
ganger83721473g_anger
gangue81310583g_angue
gannet74321853g_annet
gantlet83616243g_antlet
gantry103810113g_antry
garner73917003garn_er
garnet73928413garn_et
garnets84115413garnets
garote7717953garot_e
garoted9710133garoted
garotes8614573garotes
garotte868703garotte
garter74420513g_arter
gasted84821583g_asted
gaster75027353g_aster
gate55746573g_a_t_e
gated75329773g_a_ted
gater64533653g_a_ter
gates65939513g_a_tes
gaunter82910713gaunter
genteel836753g_enteel
gentes75324163g_entes
gentle74014513g_entle
giant65430593giant__
giantess933893giantess
giants74713503giant_s
giftee103512083g_iftee
glance94312313glan_ce
glanced11439233glanced
glancer103710073glancer
glances104113143glances
glandes95413833glandes
glinted9399373glinted
goateed9307063goa_teed
goatees82710443goa_tees
grabbed13368643grabbed
grabber12389763grabber
grabble12339643grabble
graben9419723gra_ben
grace85124543gra__ce
graced105217903gra_ced
graces94523493gra_ces
gracile102512603gracile
grackle14338893grackle
gradate9511233gradate
gradated1157433gradated
gradates10510783gradates
grade75126093gra__de
graded94919553gra_ded
grader84919693gra_der
grades84926313gra_des
gradine93317033gradine
graft95327203graft__
graftage1343683graftage
grafters12409193grafters
grafts105013253graft_s
grained93814273grained
grainer83714063grainer
grainier9218903grainier
gramme114210333gra_mme
grammes123611323grammes
gran56335013gran___
grana65722093gran__a
granary1157793granary
grand75122693gran__d
grandad1038453grandad
grandam1139393grandam
grandame1247113grandame
grandest10311573grandest
grandeur10305673grandeur
grandly1238743grandly
grandma1136913grandma
grandpa1135413grandpa
grands84218243gran_ds
grangers103011973grangers
granita82111303granita
granitas92610223granitas
granitic1168633granitic
grannies9312613grannies
granny104311163gran_ny
granola837913granola
grans64832543gran__s
grantable1257293grantable
granting103514523granting
grantors93810363grantors
grantsmen1294643grantsmen
granules939943granules
granum9310913gran_um
grape84824663gra__pe
grapes95123123gra_pes
grapey126012303gra_pey
graphed1498473graphed
grapheme1644013grapheme
grapier103712603grapier
grapnel1035603grapnel
grapple12378003grapple
grasped11409063grasped
grasper10389793grasper
grassed93812793grassed
grasses84117343grasses
grat55651283gra_t__
graters85419743gra_ters
gratin74520583gra_tin
gratine84719193gratine
gratinee93710783gratinee
gratis74819243gra_tis
graupel1034133graupel
grave94624873gra__ve
graved114818813gra_ved
gravel105313823gra_vel
graven104513523gra_ven
graver105018593gra_ver
graves104624003gra_ves
gravies11314093gravies
gravure1134953gravure
grayed115415643gra_yed
grayer106014543gra_yer
graze155820053gra__ze
grazed174115913gra_zed
grazer164815763gra_zer
grazes164519643gra_zes
grazier173611133grazier
greaten83610643greaten
greater84416493greater
gree56641563gr___ee
greeted93111383greeted
greeter82812673greeter
grenade938413grenade
grifted12379583grifted
grifter113810493grifter
grinded104210633grinded
grinder93312393grinder
grinned9378553grinned
grinner8329233grinner
grister83915413grister
gristle8169223gristle
gritted94110903gritted
gritter83913353gritter
groaned9259973groan_ed
groaner82510133groan_er
grouted94111503grouted
grouter84412523grouter
grunge8359583grun_ge
grunger9389783grunger
grunges93310403grunges
grunt65523543grunt__
grunters9359043grunters
gruntled10274943gruntled
gruntles9287233gruntles
grunts75511853grunt_s
grutten885283grutten
guanase836213guanase
guanine8810543guanine
guaranteed1251733guaranteed
guarantees1142623guarantees
gyrate104912523gyra_t_e
gyrated12428413gyra_ted
gyrates113610263gyra_tes
hanted104124313_hanted
hantle94318203_hantle
irate55627983ira_t_e
irater65218353ira_ter
kantele1138253_kantele
krater104014313kra_ter
manatee9317663_manatee
mantel84317973_mantel
mantes84430783_mantes
mantle84420923_mantle
mentee84121293_mentee
orange74016323oran_ge
oranges84215333oranges
orangey11388833orangey
orate55133303ora_t_e
orated74221503ora_ted
orates64328613ora_tes
ornate6315143ornat_e
panted95024823_panted
pantie84326473_pantie
pattee84323383_pattee
planted103516123planted
planter94017813planter
prance104318573pran_ce
pranced123714043pranced
prancer113613383prancer
prances113618783prances
pranged114512553pranged
pranked143712093pranked
prate75135983pra_t_e
prated94924923pra_ted
prater84825353pra_ter
prates84633163pra_tes
prattle9208833prattle
printed104016373printed
printer93917303printer
quanted1738973quanted
rafted104714703_rafted
rafter94517583_rafter
ragee65432663_ra_gee
raggee84217603_raggee
rakee96031173_ra_kee
ramee74633853_ra_mee
rance75028513_ran_ce
rances84625443_rances
ranees64623963_ranees
range64728423_ran_ge
ranged84824323_ranged
ranger73925533_ranger
ranges73826933_ranges
ranked114620743_ranked
ranker105021903_ranker
rankle103414883_rankle
rant45864683_rant__
ranters73323643_ranters
rants55935343_rant_s
rappee103618673_rappee
raster64731443_raster
rate45458763_ra_t_e
rated65441383_ra_ted
ratel54224883_ra_tel
rater54943283_ra_ter
rates55352013_ra_tes
rathe85821923_ra_the
ratted74923343_ratted
ratteen7329113_ratteen
ratten64217383_ratten
ratter64326313_ratter
rattle64717613_rattle
razee145827803_ra_zee
regranted1137703regranted
rente54733783_rent_e
rented74426593_rented
renter64527413_renter
rentes65431193_rentes
scanted104114393scanted
scanter94215183scanter
shantey134210043shantey
slanted83514743slanted
standee83514513standee
trainee72817793trainee
trance84718763tran_ce
tranced104414173tranced
trances93919643trances
tranche123312223tranche
truanted935373truanted
trustee73514443trustee
uranide82212093uranide
uranite72515693uranite
uranites82514643uranites
urate55432163ura_t_e
urates65027763ura_tes
wanted104319723_wanted
wanter94423053_wanter
warrantee1245283warrantee
whangee14268623whangee
wrangle1137383wrangle
wrastle10368993wrastle

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.403443402.0
2DLD Change Limit1340273476.62620227.4
3Display Results3473470.1232821.1
 (SQL Overall)1786913477.15224984.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.