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

465 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
grivets1135797(None) 
grivet103517821grivet_
privets122910051privets
rivets94417111_rivets
trivets103911581trivets
brevets12519412brevets
civets115212542_civets
drivels11397922drivels
drivers114412792drivers
drives105117112drive_s
givens10379732g_ivens
givers104817712g_ivers
gives95324872g_ive_s
gravels113611142gravels
gravers114515272gravers
graves104624002grave_s
gravest114011632gravest
greets75117422gr_eets
grides84422362gride_s
griefs10418722gri_efs
grievers1255472grievers
grieves1137322grieves
grifts104511682gri_fts
grimes94619032grime_s
griots74713642gri_ots
gripers104011462gripers
gripes94619872gripe_s
grists74716482gri_sts
grits65529582gri__ts
grovels11427812grovels
groves104318102grove_s
privet113821342privet_
revets94022182_revets
rivers94626542_rivers
rives85336002_rive_s
rivet85636362_rivet_
swivets13436962swivets
trevets10499982trevets
trijets14308262trijets
trivet93721882trivet_
aivers94822323_aivers
aridest8316143aridest
ariels65119373ari_els
arises65233803arise_s
armets84918353ar_mets
armlets94610063armlets
arrivers11137003arrivers
arrives101311513arrive_s
bidets95215533_bidets
bravers124715523bravers
braves115524083brave_s
bravest124211753bravest
breves115516433breve_s
brevet115717343brevet_
bribees11409283bribees
bribers114111503bribers
bribes105918533bribe_s
brides94423513bride_s
briefs115510073bri_efs
briers85319733bri_ers
bries74942153bri_e_s
brights133710233brights
briners94315633briners
brines85028853brine_s
briquets1934853briquets
brises84927613brise_s
briskets14346563briskets
brits76433093bri__ts
britts84813453bri_tts
brunets9419553brunets
chives144317593chive_s
civet105828733_civet_
clivers123411753clivers
corvets124715023corvets
covets114819643_covets
cravats1237413cravats
cravens124010123cravens
cravers124416563cravers
craves115825393crave_s
crickets16418123crickets
criers83918583cri_ers
cries75438403cri_e_s
crimes105521583crime_s
cripes105120873cripe_s
crises84529433crise_s
crits75527573cri__ts
cruets85314953cr_uets
crusets93811043crusets
curvets12399913curvets
derivers123811363derivers
derives114017813derive_s
diets66026643_di_ets
divers105024963_divers
diverts114412033_diverts
dives95832403_dive_s
divest106820073_divest
divests114510933_divests
divots104712203_divots
driblets11266093driblets
driers74516733dri_ers
dries64733673dri_e_s
driest74722753dri_est
drifts10499893dri_fts
drive95318003drive__
drivel105110383drive_l
driven105210143drive_n
driver104714493drive_r
drovers115212643drovers
droves105116673drove_s
duvets1039223_duvets
egrets72712243egr__ets
filets94718953_filets
fivers124420923_fivers
fives116027363_five_s
frets85523403fr__ets
friers94718933fri_ers
fries85535603fri_e_s
friges104116483frige_s
frights14339623frights
frisees104411693frisees
frises94124273frise_s
friskets15326263friskets
frites94922483frite_s
frits86129103fri__ts
fritts94613193fri_tts
frivols1334743frivols
frizers19329553frizers
frizes184015463frize_s
gadgets10348683gadgets
gaiety10119373gai_ety
gainers84214593gainers
gaiters83516543gaiters
gaits65726013gai__ts
gallets83517403gallets
gannets83811443gannets
gargets94614573gargets
garnets84115413garnets
garrets84413623garrets
garveys14124463garveys
gaskets12348153gaskets
gavels105911093g_avels
gavots1038113g_avots
genets75716663g_enets
gets55442483g___ets
giants74713503g_iants
gibbets12417723gibbets
gibers95114663g_ibers
gibes84422523g_ibe_s
giblets103210423giblets
gies55641433g_i_e_s
gifts96214963g_i_fts
giglets93211553giglets
gigots83911953g_igots
gilts64924263g_i_lts
gimels938893g_imels
gimlets10338433gimlets
girders9379943girders
girts65423623g_i_rts
gists66026193g_i_sts
gites65630183g_ite_s
gits55744603g_i__ts
give85829363g_ive__
given95915283g_ive_n
giver94921203g_ive_r
glaives11347833glaive_s
gleets75315053g_leets
gliders94811843gliders
glides84518863glide_s
glimes94717523glime_s
glints75714213gli_nts
glovers114310883glovers
gloves104115183glove_s
gobbets12327643gobbets
goblets103210183goblets
godets8410933g_odets
goglets9379783goglets
goiters84014443goiters
gorgets94711783gorgets
goriest82218743gori_est
goriness9310753goriness
grabens10367003grabens
graces94523493grace_s
graders94716013graders
grades84926313grade_s
grafts105013253gr_afts
grainers93012083grainers
grants73722473gr_ants
grapes95123123grape_s
graters85419743graters
grates75429893grate_s
grave94624873grave__
graved114818813grave_d
gravel105313823grave_l
gravely14469063gravely
graven104513523grave_n
graver105018593grave_r
gravies11314093gravies
gravitas12316023gravitas
gravity1437183gravity
grayest11489363grayest
grazers175112453grazers
grazes164519643graze_s
greats76318403gr_eats
greaves113311443greave_s
grebes93813613grebe_s
greeds84314283gr_eeds
greens75716873gr_eens
grees65132473gr__ees
greet65835323gr_eet_
greiges937733greige_s
greisens954653greisens
greyest11348343greyest
greys96614853gr__eys
gridders11286293gridders
gride75223593gride__
grided95117043gride_d
grids75321403gri__ds
grief95319783gri_e_f
grievants1342353grievants
grieve1047243gri_eve
grieved1235283grieved
griever1136033griever
grievous1243583grievous
griffes14367923griffes
griffs13398993gri_ffs
grift95924463gri_ft_
grifted12379583grifted
grifter113810493grifter
grifters12389233grifters
grigris934093grigris
grigs75318193gri__gs
grillers93810813grillers
grilles83715023grilles
grills74314803gri_lls
grilses8319153grilses
grime85021323grime__
grimed104714093grime_d
grimiest11299823grimiest
grimmest13286293grimmest
grimness1176003grimness
grinders103410423grinders
grinds84511843gri_nds
gringas938043gringas
gringos936673gringos
grinners9288043grinners
grins65427223gri__ns
griot65328413gri_ot_
gripe84622963gripe__
griped104114713gripe_d
griper94114613gripe_r
gripey124111203gripe_y
gripiest11289633gripiest
grippers13358133grippers
grippes124810373grippes
grips85520133gri__ps
gript85126173gri_pt_
griseous945613griseous
grisette994653grisette
grisettes1094713grisettes
grisons838993grisons
grist65529873gri_st_
grister83915413grister
gristers94013413gristers
grit55247243gri__t_
grith95520373gri__th
griths105211653gri_ths
gritted94110903gritted
gritter83913353gritter
gritters94210633gritters
gritty10338403gri_tty
groats74816653gr_oats
grocers103511253grocers
grommets13234663grommets
groovers12337123groovers
grooves11368803groove_s
gropers104813853gropers
gropes95220403grope_s
grots65025853gr__ots
grouts75015613gr_outs
grove95219333grove__
groved114413703grove_d
grovel104310543grove_l
growers113612723growers
gruels73910153gr_uels
grues65721963gr_ue_s
grumes94415553grume_s
grummets13275033grummets
grunts75511853gr_unts
guglets9369693guglets
guiders94111113guiders
guides84118283guide_s
guiles73919283guile_s
guilts74111233gui_lts
guineas836753guineas
guises74216313guise_s
gullets84013713gullets
gurglets10355543gurglets
gurnets84010793gurnets
gussets837443gussets
gyves125711553g_yve_s
hives116925513_hive_s
irides74519123iride_s
irises64221173irise_s
jivers164515643_jivers
jives154820813_jive_s
knives13458553knive_s
krises105016083krise_s
livens94314893_livens
livers94927823_livers
lives86133193_live_s
livest95315733_livest
naives94914223naive_s
naivest10309473naivest
naivete1055663naivete
naivetes1145113naivetes
naivety1344283naivety
ogives10367913ogive_s
olives94313953olive_s
oriels64914623ori_els
orients7311583orients
pipets105714773_pipets
pivots115111903_pivots
presets94216423presets
prevents133012303prevents
pricers113915063pricers
prices104524543price_s
prickets16329083prickets
prides94324183pride_s
priers84521193pri_ers
pries74339533pri_e_s
priest84125423pri_est
priests93810863priests
primers114215673primers
primes104225263prime_s
prints84320103pri_nts
prises84133173prise_s
private121513263private
privates131812383privates
privies122414263privies
priviest132310313priviest
privity15268323privity
prizers183911843prizers
prizes173819813prize_s
projets1639163projets
provers123817793provers
proves114322253prove_s
quiets154014373qui_ets
quivers19298753quivers
ramets83517393_ramets
ravels94717073_ravels
ravens93916883_ravens
ravers94628183_ravers
raves85441973_rave_s
reivers105117083reivers
reives95723043reive_s
relets64025673_relets
resets65427613_resets
rets45352563_r__ets
revels94220573_revels
revers94529633_revers
reverts104715053_reverts
revest94623603_revest
revests104413743_revests
revet84938843_revet_
rewets94617213_rewets
ribes75530173_ribe_s
riblets93412553_riblets
ricers84120993_ricers
rices75536153_rice_s
rickets134915093_rickets
riders74123903_riders
rides66140823_ride_s
riels55121333_ri_els
rievers104311453_rievers
rifest93114583_rifest
rifts85718643_ri_fts
rights104019333_rights
riles55343643_rile_s
rillets74216153_rillets
rimers84522553_rimers
rimes75634543_rime_s
riots54922013_ri_ots
ripens85012173_ripens
ripes75435773_ripe_s
ripest84317943_ripest
risers64624783_risers
rises55244043_rise_s
rites54442553_rite_s
rivals94213183_rivals
rive75537733_rive__
rived94825613_rive_d
riven85121623_rive_n
river85731693_rive_r
riveted11258573_riveted
riveter10208753_riveter
riveters11228163_riveters
rivulets1174753_rivulets
rosets65819953_rosets
rovers95423523_rovers
roves84834483_rove_s
scrives124414273scrive_s
shivers133714833shivers
shives124921413shive_s
shrivels14376443shrivels
shrivers14419103shrivers
shrives134416173shrive_s
sivers95324153_sivers
skivers14409703skivers
skives134113943skive_s
slivers104115253slivers
snivels10336903snivels
soviets1087293soviets
spinets94714813spinets
stivers103613543stivers
strivers113911843strivers
strives104119373strive_s
swivels13396773swivels
swives123915183swive_s
swivet123615473swivet_
thrivers14456823thrivers
thrives134611713thrive_s
toilets74112913toilets
travels104711293travels
traves94222743trave_s
trets55928023tr__ets
trevet94818913trevet_
tribes85119023tribe_s
triceps11267343triceps
trices84826333trice_s
tricots9311563tricots
tridents938583tridents
triens65417543tri_ens
triers64321523tri_ers
tries55742813tri_e_s
trijet133916553trijet_
trikes105419493trike_s
trimers94615143trimers
trines64132563trine_s
trinkets1237143trinkets
triolets83410143triolets
tripes85324873tripe_s
triplets103510263triplets
trippets12357423trippets
trisects1035983trisects
tritest7315273tritest
trovers103713323trovers
troves94719113trove_s
uprivers13215563uprivers
urines64724123urine_s
velvets13326693velvets
vervets13419753vervets
vets76835093___vets
vivers124717363_vivers
waivers133410053waivers
waives123714183waive_s
wivers125320803_wivers
wives115328923_wive_s
wries85827743wri_e_s
wriest94419713wri_est
wrights14318993wrights
wrists95415643wri_sts
writers105513493writers
writes94420333write_s
writs86624383wri__ts
zibets1737743_zibets

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.436409841.7
2DLD Change Limit1340274656.56320421.6
3Display Results4654650.1562980.8
 (SQL Overall)1786914657.15524974.3
 
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.