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

291 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
groovy1337540(None) 
groove10438871groove
broody124510082broody
broomy13449952broomy
drooly104911072drooly
droopy12458242droopy
gloomy12528762gloomy
goody105620392g_oody
gooey95522862g_ooey
goofy124915622g_oofy
gooky135818032g_ooky
goony95519782g_oony
goopy115816622g_oopy
goosy96018882g_oosy
gravy125512112gr_avy
grody103412062gr_ody
groggy1234802groggy
groom85317982groo_m
grooms94512522grooms
grooved12347252grooved
groover11358542groover
grooves11368802grooves
groszy19395702groszy
grotty10389832grotty
grouty104710982grouty
grove95219332gr_ove
growly13499172growly
rooky126117622_rooky
roomy107118062_roomy
rooty86423022_rooty
agrology1336023agrology
agronomy1443983agronomy
argosy1036423argosy
armory114211473armory
arrowy12288273arrowy
bloody124710173bloody
blooey115110793blooey
bloomy134510113bloomy
booby125319513_booby
boody115420403_boody
boogy114518323_boogy
boomy125421823_boomy
booty106125913_booty
boozy194917063_boozy
briony1149043briony
brolly114510853brolly
bronzy20306713bronzy
broo65129823broo__
brooch13368443brooch
brood84620243broo_d
broods95416383broods
brook114717763broo_k
brooks125813883brooks
broom95022213broo_m
brooms104915873brooms
broos75126413broo_s
brosy106115383br_osy
brothy14519623brothy
browny144510043browny
bryony1435833bryony
choosy14459103choosy
cooey105828223_cooey
cooky145321363_cooky
cooly105525423_cooly
corody12149703corody
croaky15528483croaky
crony105918673cr_ony
crook115217573croo_k
crooks124914413crooks
croon75522783croo_n
croons85418423croons
croupy13458733croupy
crowdy15467173crowdy
dhooly13457143dhooly
doody105517913_doody
dooly94821803_dooly
doomy116018263_doomy
doozy186813713_doozy
drolly105411673drolly
drool65416103droo_l
drools74412813drools
droop85814823droo_p
droops95110963droops
dropsy12497473dropsy
drosky14486163drosky
drossy10528473drossy
drove95518063dr_ove
drowsy13487903drowsy
flooey123910173flooey
floosy12368153floosy
floozy21356613floozy
footy115820533_footy
froggy1434493froggy
frosty124710633frosty
frothy15578373frothy
frouzy21395283frouzy
frowsy15498273frowsy
frowzy24485793frowzy
geology12257323geology
ghosty13467213ghosty
globby1434683globby
gloom87116523gloo_m
glooms96211683glooms
gloppy1454723gloppy
glory96413293g_lory
glossy10549003glossy
glove94516293g_love
gobony1236913gobony
goby106021083g__oby
godly104913293g_odly
golly95121103g_olly
goo47754773g_oo__
good66531803g_oo_d
goodby13406283goodby
goodly11419303goodly
goods75124483g_oods
goof85436873g_oo_f
goofs94821003g_oofs
googly11417883googly
gook96429603g_oo_k
gooks105422883g_ooks
goon57236173g_oo_n
gooney106612313gooney
goons65326773g_oons
goop75829483g_oo_p
goops86620963g_oops
goos57644913g_oo_s
goose65925903g_oose
goosey105913513goosey
gorily10612503gorily
gorsy95915783g_orsy
gory86129663g__ory
gouty95217363g_outy
goy77844553g__o_y
grabby14336183grabby
grainy103914213grainy
granny104311163granny
grapey126012303grapey
grapy115416433gr_apy
grassy10619093grassy
grave94624873gr_ave
gray85329893gr__ay
grayly13287963grayly
greasy10419463greasy
greave104611493greave
greedy11518843greedy
greeny104811453greeny
gremmy1454473gremmy
grey85624043gr__ey
greyly13316543greyly
grieve1047243grieve
grimly12459933grimly
grimy114312603gr_imy
griot65328413grio_t
griots74713643griots
gripey124111203gripey
grippy14447763grippy
gripy115115253gr_ipy
grisly104310583grisly
gritty10338403gritty
groan65618423gr_oan
groans74815063groans
groat65531973gr_oat
groats74816653groats
grocer94212143grocer
grocery13336763grocery
grog65923343gr_o_g
grogs76319413gr_ogs
groin65521083gr_oin
groins73917203groins
grok95819683gr_o_k
groks105716123gr_oks
groomed11379503groomed
groomer10399873groomer
groovers12337123groovers
groovier1233793groovier
grooving13286713grooving
grope84821613gr_ope
groped107515053groped
groper94517253groper
gropes95220403gropes
gross65421693gr_oss
grossly1175983grossly
grosz154814093gr_osz
grosze16457733grosze
grot55942053gr_o_t
grots65025853gr_ots
grotto7349813grotto
grouch12318473grouch
grouchy16294243grouchy
ground82310273ground
group85413923gr_oup
groups94210513groups
grouse74315023grouse
grout65330423gr_out
grouts75015613grouts
groved114413703groved
grovel104310543grovel
groves104318103groves
grow86127303gr_o_w
grower104614933grower
growl96115823gr_owl
growls104711113growls
grown95317353gr_own
grows95523923gr_ows
growth1377383growth
growthy1773283growthy
groyne1037213groyne
grubby14324503grubby
gruffy16396013gruffy
grumpy14498153grumpy
grungy11345973grungy
hoody124919723_hoody
hooey114926603_hooey
hooky155220263_hooky
hooly115022223_hooly
hooty115022443_hooty
irony85015903ir_ony
kooky114412873_kooky
kroon94514483kroo_n
krooni10397183krooni
kroons103711243kroons
looby108115623_looby
looey84822913_looey
loony86918963_loony
loopy105316643_loopy
moody115017493_moody
moony104818273_moony
moory105115793_moory
nooky124814813_nooky
oozy167018133__oozy
orology11319463orology
phooey14379233phooey
poofy136213273_poofy
poove104514303_poove
priory114110263priory
privy13439833pr_ivy
proof105221533proo_f
proofs114511683proofs
prosody1336433prosody
prosy106319253pr_osy
prove104823193pr_ove
proxy175011013pr_oxy
ptooey11346413ptooey
regroove1243673regroove
rocky144513853_rocky
roily86121113_roily
rood56733003_roo_d
roods65125283_roods
roof75738833_roo_f
roofs85321153_roofs
rook85532033_roo_k
rooks95325043_rooks
room66235083_roo_m
rooms75324683_rooms
roose56127093_roose
roost55730933_roost
root45655923_roo_t
roots55933673_roots
ropey106021873_ropey
ropy96323413_r_opy
rosy76024873_r_osy
roupy106112713_roupy
rove75136983_r_ove
rowdy125711533_rowdy
snoopy11449473snoopy
snooty94211513snooty
snoozy18517233snoozy
sooey84522433_sooey
sooty84924843_sooty
spoofy14498553spoofy
spooky15418093spooky
spoony114111793spoony
swoony12408263swoony
swoopy14487283swoopy
trolly94012363trolly
troop76417533troo_p
troops85712783troops
trooz145016153troo_z
trophy1438283trophy
trouty95211793trouty
trove85221923tr_ove
troy77429683tr_o_y
urology11217583urology
vroom105312473vroo_m
vrooms11398713vrooms
woody125116883_woody
wooly114417673_wooly
woozy204410603_woozy
zooey173914803_zooey
zooty175415353_zooty

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.1401276364.3
2DLD Change Limit1127162915.45320670.5
3Display Results2912910.0803637.5
 (SQL Overall)1786912915.67331498.5
 
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.