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

402 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
groove1043887(None) 
grooved12347251grooved
groover11358541groover
grooves11368801grooves
groovy13375401groovy
grove95219331gr_ove
drove95518062dr_ove
glove94516292g_love
goose65925902g_oose
grave94624872gr_ave
greave104611492greave
grieve1047242grieve
groom85317982groo_m
groomed11379502groomed
groomer10399872groomer
grooms94512522grooms
groovers12337122groovers
groovier1233792groovier
grope84821612gr_ope
grosze16457732grosze
grouse74315022grouse
groved114413702gr_oved
grovel104310542gr_ovel
groves104318102gr_oves
groyne1037212groyne
poove104514302_poove
prove104823192pr_ove
regroove1243672regroove
roose56127092_roose
rove75136982_r_ove
trove85221922tr_ove
above105414323_above
alcove1178093alcove
areole61017283areole
ariose64818723ariose
arkose104911343arkose
arose55832083ar_ose
arouse65019983arouse
arrive91311793arrive
behoove1553773behoove
behove14207203behove
blooie83913193blooie
booze164718913_booze
brave104925503br_ave
breve105317053br_eve
broche133612103broche
brogue94211033brogue
broke116019783br_oke
brome94421973br_ome
bronze173610923bronze
broo65129823broo__
brooch13368443brooch
brood84620243broo_d
brooded113510933brooded
brooder103811623brooder
broods95416383broods
broody124510083broody
brook114717763broo_k
brooked143610033brooked
brookie1347373brookie
brooks125813883brooks
broom95022213broo_m
broomed124111053broomed
brooms104915873brooms
broomy13449953broomy
broos75126413broo_s
brose75227033br_ose
browse115713853browse
choose115116143choose
clove105619443_clove
cooee74531023_cooee
cove95837073__cove
crave105626313cr_ave
creole8913733creole
crone75231333cr_one
crook115217573croo_k
crooked143910943crooked
crooker134111093crooker
crooks124914413crooks
croon75522783croo_n
crooned103813343crooned
crooner93714043crooner
croons85418423croons
crore74922873cr_ore
crosse85216303crosse
croupe105114433croupe
crouse84619363crouse
croute84617273croute
croze164719453cr_oze
dove85131563__dove
drave95219273dr_ave
drive95318003dr_ive
drogue8938333drogue
drone65324983dr_one
drool65416103droo_l
drooled9369203drooled
drools74412813drools
drooly104911073drooly
droop85814823droo_p
drooped11368433drooped
droops95110963droops
droopy12458243droopy
droved114611643dr_oved
drover104614593dr_over
droves105116673dr_oves
drowse105010553drowse
erode64520993er_ode
erose55727273er_ose
erosive1039193erosive
evolve12306503evolve
flooie93712153flooie
froe75329993fr_o_e
frore86218803fr_ore
froze174515653fr_oze
galore73514873galore
garote7717953garote
garotte868703garotte
garrote8510103garrote
gave84634053g__ave
gemote94613023gemote
genome94312193genome
geode7412593g_eode
girolle835793girolle
give85829353g__ive
glaive10357933glaive
globe84917013g_lobe
globose1035543globose
gloom87116523gloo_m
gloomed11337413gloomed
glooms96211683glooms
gloomy12528763gloomy
gloved114811873g_loved
glover104513533g_lover
gloves104115183g_loves
gloze154815983g_loze
gnome84213953g_nome
gone55639043g__one
goo47754773g_oo__
goober93911743g_oober
good66531803g_oo_d
goodie83613993goodie
goods75124483g_oods
goody105620393g_oody
gooey95522863g_ooey
goof85436873g_oo_f
goofed114911383g_oofed
goofs94821003g_oofs
goofy124915623g_oofy
gooier73516213g_ooier
gook96429603g_oo_k
gooks105422883g_ooks
gooky135818033g_ooky
goon57236173g_oo_n
gooney106612313g_ooney
goonie73615563goonie
goons65326773g_oons
goony95519783g_oony
goop75829483g_oo_p
goops86620963g_oops
goopy115816623g_oopy
goos57644913g_oo_s
goosed86817033g_oosed
gooses75723053g_ooses
goosey105913513g_oosey
goosy96018883g_oosy
gore55744963g__ore
gorge76423893g_orge
gorse65926813g_orse
gouge78220063g_ouge
grace85124543gr_ace
grade75126093gr_ade
gramme114210333gramme
grange83716203grange
grape84824663gr_ape
grate64932883gr_ate
graved114818813gr_aved
gravel105313823gr_avel
graven104513523gr_aven
graver105018593gr_aver
graves104624003gr_aves
gravy125512113gr_avy
graze155820053gr_aze
grease75416233grease
greaved12408913greaved
greaves113311443greaves
grebe85114943gr_ebe
gree56641563gr__ee
greige847203greige
gride75223583gr_ide
grieved1235283grieved
griever1136033griever
grieves1137323grieves
griffe13438093griffe
grille74315743grille
grilse7399503grilse
grime85021323gr_ime
griot65328413grio_t
griots74713643griots
gripe84622963gr_ipe
grippe115310323grippe
grivet103517823gr_ivet
groan65618423gr_oan
groaned9259973groaned
groaner82510133groaner
groans74815063groans
groat65531973gr_oat
groats74816653groats
grocer94212143grocer
grodier939673grodier
grody103412063gr_ody
grog65923343gr_o_g
groggy1234803groggy
grogs76319413gr_ogs
groin65521083gr_oin
groined92710813groined
groins73917203groins
grok95819683gr_o_k
grokked1233673grokked
groks105716123gr_oks
grommet12268453grommet
groomers11388483groomers
grooviest1334083grooviest
grooving13286713grooving
groped107515053groped
groper94517253groper
gropes95220403gropes
gross65421693gr_oss
grossed93812253grossed
grosser84313143grosser
grosses84517683grosses
grosz154814093gr_osz
groszy19395703groszy
grot55942053gr_o_t
grots65025853gr_ots
grotto7349813grotto
grotty10389833grotty
grouch12318473grouch
ground82310273ground
group85413923gr_oup
grouped11419193grouped
grouper104210093grouper
groupie1045783groupie
groups94210513groups
groused94712833groused
grouser84513693grouser
grouses84616543grouses
grout65330423gr_out
grouted94111503grouted
grouter84412523grouter
grouts75015613grouts
grouty104710983grouty
grovels11427813gr_ovels
grow86127303gr_o_w
grower104614933grower
growl96115823gr_owl
growled12278173growled
growler11318973growler
growls104711113growls
growly13499173growly
grown95317353gr_own
grows95523923gr_ows
growth1377383growth
groynes1137823groynes
grudge9388583grudge
grue55825713gr__ue
grume86218163gr_ume
grumose1035723grumose
grunge8359583grunge
gyrose105310253gyrose
gyve116215083g__yve
hooved134713123_hooved
hoover124314433_hoover
hooves124815483_hooves
hove107132223__hove
inwove12167273inwove
irone55126363ir_one
krone94018733kr_one
kroon94514483kroo_n
krooni10397183krooni
kroons103711243kroons
looie55624243_looie
loose56627683_loose
love75234763__love
moose76327193_moose
morose85116243morose
move96630723__move
noose55624063_noose
ooze136420603__ooze
orgone71110913orgone
oriole6814293oriole
oroide7311703oroide
pooves113914713_pooves
porose84818743porose
probe94320813pr_obe
prole74527793pr_ole
promote11313143promote
prone75332623pr_one
proof105221533proo_f
proofed13138723proofed
proofer12149103proofer
proofs114511683proofs
propone112716303propone
propose112714843propose
prose75835123pr_ose
proved125016033pr_oved
proven114314773pr_oven
prover113819723pr_over
proves114322253pr_oves
provoke1676123provoke
rave75542093_r_ave
reave84528023_reave
reeve84121323_reeve
regrooved1443253regrooved
regrooves1343863regrooves
reive85522943_reive
remove116115573remove
rewove126420083rewove
rive75537723_r_ive
robe65335643_r_obe
roble75223023_roble
rode55844303_r_ode
roe36861083_r_o_e
rogue66417533_rogue
role45851823_r_ole
rood56733003_roo_d
roods65125283_roods
roof75738833_roo_f
roofed105214743_roofed
roofer94415283_roofer
roofie93411173_roofie
roofs85321153_roofs
rook85532033_roo_k
rooked114918143_rooked
rookie103613263_rookie
rooks95325043_rooks
rooky126117623_rooky
room66235083_roo_m
roomed95218543_roomed
roomer84718633_roomer
roomie83013873_roomie
rooms75324683_rooms
roomy107118063_roomy
roosed75621593_roosed
rooser63921883_rooser
rooses65526233_rooses
roost55730933_roost
root45655923_roo_t
rooted75424003_rooted
rooter64926033_rooter
rootle63214453_rootle
roots55933673_roots
rooty86423023_rooty
rope65542913_r_ope
roque144812133_roque
rose46148903_r_ose
rote46249023_r_ote
rotte54625933_rotte
roue45941743_r_oue
rouge65423443_rouge
rouse56634703_rouse
route55132073_route
roved95323553_r_oved
roven85521973_r_oven
rover85527373_r_over
roves84834483_r_oves
scrooge1037183scrooge
shove114421043_shove
shrove125412233shrove
snooze15439993snooze
soave84219053_soave
solve85618943_solve
stooge73811663stooge
stove85220253_stove
strove95014793strove
throve128012393throve
torose64317693torose
trave85223033tr_ave
triode75311893triode
triose64715383triose
troche113112513troche
trode65322853tr_ode
troke94821053tr_oke
trompe105611263trompe
trone55131863tr_one
troop76417533troo_p
trooped104010723trooped
trooper94210363trooper
troops85712783troops
trooz145016153troo_z
trope75725803tr_ope
troupe84812433troupe
trover95014663tr_over
troves94719113tr_oves
unrove92511683unrove
unwove12238883unwove
updove1234483updove
uphove1436133uphove
vroom105312473vroo_m
vroomed13366433vroomed
vrooms11398713vrooms
wove105624313__wove
wrote84717483wr_ote

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127164024.84623259.6
3Display Results4024020.1233268.3
 (SQL Overall)1786914025.34233450.2
 
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.