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

428 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
grafters1240918(None) 
crafters13419941crafters
drafters12338521drafters
grafter114211151grafter_
granters93614131granters
graters85419731gra_ters
grifters12389231grifters
rafters103715631_rafters
afters94717072__afters
crafter124111332crafter_
craters95021882cra_ters
crofters13358892crofters
draftees12225252draftees
drafter11449422drafter_
drifters12417912drifters
fraters103517202fra_ters
gaffers14428712g_affers
gaiters83516532g_aiters
garters84218222g_arters
gasters85624282g_asters
gaters74728632g_a_ters
grabbers13337882grabbers
graders94715992gra_ders
grafted124110222grafte_d
grafts105013252graft__s
grainers93012072grainers
grangers103011972grangers
grantees92510972grantees
granter84117132granter_
grantors93810352grantors
graspers11338392graspers
grater74625432gra_ter_
grates75429882gra_te_s
gravers114515262gra_vers
grazers175112442gra_zers
graziers18387122graziers
greeters92610112greeters
grifter113810492grifter_
gristers94013402gristers
gritters94210632gritters
grouters95910062grouters
grunters9359022grunters
hafters134614332_hafters
kraters114212332kra_ters
praters94921642pra_ters
rafter94517582_rafter_
ranters73323642_ranters
rasters74629022_rasters
raters63936572_ra_ters
ratters74422472_ratters
wafters134112812_wafters
abaters95115193aba_ters
adapters1136103adapters
after85719793__after_
agrafes1137523agraf_e_s
agraffes1553043agraffe_s
alters64924223__alters
arbiters1038853arbiters
asters65631603__asters
awaiters1146643awaiters
baiters94619303_baiters
banters94623113_banters
barters94223033_barters
basters94930303_basters
batters94626013_batters
beaters94925033bea_ters
blasters104116143blasters
blatters104414093blatters
boasters103915653boasters
boaters93419233boa_ters
bracers114616703bra_cers
braggers12327903braggers
braiders114110573braiders
branders114313093branders
branners104010923branners
brasiers103710513brasiers
bravers124715523bra_vers
brawlers13408643brawlers
brayers124511903bra_yers
brazers184513943bra_zers
braziers19397193braziers
bruiters10329133bruiters
canters94827723_canters
carters95327243_carters
casters94729893_casters
caters85336493_ca_ters
chafers154512723chaf_ers
chaffers19377993chaffers
chanters134016723chanters
chapters154012113chapters
charters134115563charters
chatters134213933chatters
clatters103313903clatters
coasters104317303coasters
coaters93525773coa_ters
crabbers14358743crabbers
crackers164111723crackers
cradlers11309183cradlers
crafted13419773crafte_d
craftier1376193craftier_
crafts115312743craft__s
crammers14369343crammers
crappers144011023crappers
crashers134013223crashers
crater85026633cra_ter_
crates85736053cra_te_s
cravers124416543cra_vers
crawlers13309003crawlers
critters103511313critters
crofter12299573crofter_
dafter104813343_dafter_
darters84017603_darters
daters74827363_da_ters
diasters92913173diasters
drafted12439033drafte_d
draftee11379523drafte_e
draftier1285263draftier_
drafts105012533draft__s
draggers11357383draggers
dragsters1134323dragsters
drainers92811253drainers
drapers105313353dra_pers
drawers113610073dra_wers
drawlers12307313drawlers
drifter11348703drifter_
easters75125683_easters
eaters65535943_ea_ters
elaters74420183ela_ters
erasers74413943era_sers
erecters102611613erecters
exacters1736773exacters
exalters1536653exalters
falters103916473_falters
feasters11511563feasters
flatters113814203flatters
fracturs13146303fracturs
frakturs15163253frakturs
framers125113823fra_mers
frankers15348353frankers
frater94520593fra_ter_
fretters113410303fretters
fritters113810783fritters
fruiters11328173fruiters
gabbers124612833g_abbers
gadders103611503g_adders
gaffer134310133g_affer_
gaffes134811103g_affe_s
gagers84021323g_a_gers
gaggers103413663g_aggers
gagsters10317073gagsters
gainers84214593g_ainers
gaiter73819503g_aiter_
gamers94420823g_a_mers
gammers123214563g_ammers
ganders93521703g_anders
gangers94418603g_angers
gaolers83511563g_aolers
gapers94520463g_a_pers
garblers113810283garblers
garglers10418263garglers
garners83815983g_arners
garotes8614563garote_s
garotters1055033garotters
garroters1055813garroters
garter74420513g_arter_
gaspers105014133g_aspers
gassers84714633g_assers
gaster75027353g_aster_
gater64533643g_a_ter_
gates65939503g_a_te_s
gathers114315063g_athers
gators74115823g_a_tors
gauffers1563833gauffers
gaugers94211703g_augers
gawkers15347453g_awkers
gawpers13448313g_awpers
gazers164516293g_a_zers
getters84216093g_etters
giantess933893giantess
giftees11306513g_iftees
giraffes1542603giraffe_s
glaciers11277893glaciers
glancers11408003glancers
glanders103811503glanders
glazers174410033gla_zers
glaziers18406563glaziers
glisters93912603glisters
glitters93710543glitters
gloaters9288853gloaters
gnawers11356383gna_wers
goatees82710433goa_tees
gofers104711513g_of_ers
goffers14409213g_offers
goiters84014433g_oiters
golfers114410083golf_ers
grabber12389763grabber_
grabblers14345513grabblers
grabens10367003gra_bens
graces94523493gra_ce_s
gradates10510783gradate_s
grader84919693gra_der_
grades84926313gra_de_s
graft95327203graft___
graftage1343683graftage
graftages1443683graftages
grafting13319623grafting
grainer83714063grainer_
grammars13345943grammars
grammes123611323gramme_s
grandees103211283grandees
grander93315873grander_
grandeurs11335103grandeurs
granger93514213granger_
granges93516523grange_s
granites92116363granite_s
granted94715103grante_d
grantee83217133grante_e
grantor84010933grantor_
grants73722473grant__s
grapery13457953gra_pery
grapes95123123gra_pe_s
grapier103712603grapier_
grapnels1134393grapnels
grapplers14274303grapplers
grasper10389783grasper_
grasses84117343grasse_s
grate64932883gra_te__
grated84523923gra_te_d
gratifiers1443863gratifiers
gratins84119183gra_tins
gratis74819243gra_t_is
graupels1133103graupels
gravels113611143gra_vels
graver105018593gra_ver_
graves104624003gra_ve_s
gravies11314093gravie_s
gravures1234903gravures
grayer106014543gra_yer_
grayness1235933grayness
graywaters1742553graywaters
grazer164815763gra_zer_
grazes164519643gra_ze_s
grazier173611133grazier_
greasers93410253greasers
greatens9307593greatens
greater84416493greater_
greeter82812673greeter_
gridders11286293gridders
grievers1255473grievers
griffes14367923griffe_s
grifted12379583grifte_d
grifts104511683grift__s
grillers93810803grillers
grinders103410423grinders
grinners9288043grinners
gripers104011463gr_ipers
grippers13358123grippers
grister83915413grister_
gritter83913353gritter_
groaners9248493groaners
grocers103511253gr_ocers
groomers11388483groomers
groovers12337123groovers
gropers104813853gr_opers
grossers94410973grossers
groupers11358633groupers
grousers93810723grousers
grouter84412523grouter_
growers113612723gr_owers
growlers12327093growlers
grubbers13316193grubbers
grudgers11266743grudgers
gruelers936173gruelers
gruffer1475793gruffer_
grungers10298503grungers
grunter83110783grunter_
guarders1035873guarders
gutters83715503g_utters
gypsters1434023gypsters
gyrates113610263gyra_te_s
gyrators1245993gyra_tors
hafter124815883_hafter_
halters104619803_halters
haters94930393_ha_ters
hatters104221523_hatters
heaters104225213hea_ters
hefters134312003_hefters
hereafters1643593hereafters
irater65218343ira_ter_
krafts13438853kraft__s
krater104014313kra_ter_
lasters75627693_lasters
lifters104313773_lifters
loafers10349463loaf_ers
lofters103912903_lofters
maftirs1236043_maftirs
masters94628923_masters
maters85032383_ma_ters
matters94421753_matters
natters73718063_natters
oaters65029783_oa_ters
orates64328613ora_te_s
orators7313803ora_tors
orbiters1036593orbiters
palters94021683_palters
pasters94531733_pasters
paters84935823_pa_ters
patters94825193_patters
piaffers16114203piaffers
piasters102912803piasters
plaiters103512633plaiters
planters102915323planters
plasters103518133plasters
platers93924083pla_ters
platters103415283platters
poofters1336923poofters
praetors1039833praetors
praisers103410833praisers
prancers123210333prancers
prater84825353pra_ter_
prates84633163pra_te_s
prattlers11195323prattlers
prawners1346003prawners
prayers124212853pra_yers
prealters1147773prealters
prefers123713333pref_ers
presters103419003presters
printers103214903printers
proffers16126593proffers
profiters14228313profiters
psalters10227713psalters
quaffers2333963quaffers
quarters173110443quarters
racers84725433_ra_cers
rackers134320453_rackers
rafflers14317363_rafflers
rafted104714703_rafte_d
raftered1237663_raftered
rafts87820633_raft__s
raiders84615143_raiders
railers74420663_railers
raisers73617393_raisers
rakers104123573_ra_kers
rammers113715043_rammers
rangers83621043_rangers
rankers113217463_rankers
ranter63826823_ranter_
rapers84327183_ra_pers
rapiers95012873_rapiers
rappers113618443_rappers
raptors94213353_raptors
rasers64526783_ra_sers
rashers104020903_rashers
raspers94415913_raspers
raster64731443_raster_
ratels64518213_ra_tels
rater54943283_ra_ter_
rates55352013_ra_te_s
rattens74213403_rattens
ratter64326313_ratter_
rattlers83510293_rattlers
ravers94628183_ra_vers
razers154919613_ra_zers
realters83614043realters
refers93921083_ref_ers
refuters11449603_refuters
renters74224813_renters
resters74130403_resters
riflers103512193_riflers
rioters73615503_rioters
ritters74020613_ritters
roasters83615913roasters
rooters74522933_rooters
rosters73727533_rosters
rotters74421393_rotters
routers74822853_routers
salters73622253_salters
scatters103612753scatters
seaters74028933sea_ters
shatters113313903shatters
shifters14319853shifters
sifters103714783_sifters
skaters113512943ska_ters
slaters73123723sla_ters
smatters104011713smatters
snifters11318603snifters
spatters103914703spatters
staffers14247083staffers
starters83714763starters
staters73922323sta_ters
strafers11379903straf_ers
swatters113911793swatters
swifters14277483swifters
tasters74225643_tasters
taters64932193_ta_ters
tatters74520483_tatters
toasters83912703toasters
tracers94917833tra_cers
trackers143512843trackers
tractors10312553tractors
traders84316943tra_ders
trailers82912913trailers
trainers83114633trainers
traitors8310773traitors
trampers123210373trampers
trappers123711023trappers
trashers113013623trashers
trawlers113310193trawlers
treaters83615823treaters
triflers113110213triflers
troffers14125423troffers
trotters83310233trotters
trusters83112243trusters
trysters11298363trysters
tufters10298343_tufters
urates65027763ura_te_s
ureters7311823ur_eters
wafers124316143_waf_ers
wafter124114613_wafter_
waiters104218623_waiters
wanters104420093_wanters
wasters104026593_wasters
waters95030623_wa_ters
wrappers15306933wrappers
wresters112711733wresters
writers105513493wr_iters
yatters103914623_yatters
zaffers22386773_zaffers

Search took 9 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.1731032896.0
2DLD Change Limit1461624288.53017135.1
3Display Results4284280.1732474.0
 (SQL Overall)1786914288.87620131.9
 
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.