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

365 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
grooves1136880(None) 
groove10438871groove_
grooved12347251grooved
groover11358541groover
groovers12337121groovers
groves104318101gr_oves
droves105116672dr_oves
gloves104115182g_loves
gooses75723052g_ooses
graves104624002gr_aves
greaves113311442greaves
grieves1137322grieves
groomed11379502groomed
groomer10399872groomer
groomers11388482groomers
grooms94512522groo_ms
groovier1233792groovier
grooviest1334082grooviest
groovy13375402groov_y
gropes95220402gr_opes
grosses84517682grosses
grouses84616542grouses
grove95219332gr_ove_
groved114413702gr_oved
grovel104310542gr_ovel
grovels11427812gr_ovels
groynes1137822groynes
hooves124815482_hooves
pooves113914712_pooves
proves114322252pr_oves
regrooves1343862regrooves
rooses65526232_rooses
roves84834482_r_oves
troves94719112tr_oves
aboves114512843_aboves
alcoves1297873alcoves
arbores94016033arbores
areoles71016953areoles
arkoses113910833arkoses
arouses74921293arouses
arrives101311513arrives
behooves1653793behooves
behoves15177353behoves
boozes174916523_boozes
braves115524083br_aves
bravoes12418533bravoes
breves115516423br_eves
brogues10719823brogues
bromes104719763br_omes
bronzes183510403bronzes
brooches15288193brooches
brooded113510933brooded
brooder103811623brooder
brooders112610243brooders
broods95416383broo_ds
brooked143610033brooked
brookies1459143brookies
brooks125813883broo_ks
broomed124111053broomed
brooms104915873broo_ms
broos75126413broo__s
broses86524403br_oses
browses124712693browses
chooses125717423chooses
cloves114918823_cloves
cooees85621893_cooees
corves115122523_corves
coves105539173__coves
craves115825393cr_aves
creoles9913323creoles
crones84729243cr_ones
cronies9622503cronies
crooked143910943crooked
crooker134111093crooker
crookest1436683crookest
crooks124914413croo_ks
crooned103813343crooned
crooner93714043crooner
crooners103911393crooners
croons85418423croo_ns
crores86121163cr_ores
crosses94220793crosses
croupes114613103croupes
croutes94815653croutes
crozes174417663cr_ozes
doves94728153__doves
drives105117113dr_ives
drogues9398393drogues
drones75023433dr_ones
drooled9369203drooled
drools74412813droo_ls
drooped11368433drooped
droops95110963droo_ps
drosses84513823drosses
drove95518063dr_ove_
droved114611643dr_oved
drover104614593dr_over
drovers115212643dr_overs
drowses114610233drowses
erodes74819883er_odes
eroses65327053er_oses
evolves13286743evolves
froes86126693fr_o_es
frontes104214163frontes
galores82614323galores
garotes8614563garotes
garottes978283garottes
garrotes969363garrotes
gemotes103712143gemotes
genomes103611703genomes
geodes8412153g_eodes
girolles935523girolles
gives95324873g__ives
glaives11347833glaives
globes94314543g_lobes
gloomed11337413gloomed
glooms96211683gloo_ms
glories81915913glories
glosses84014123glosses
glove94516293g_love_
gloved114811873g_loved
glover104513533g_lover
glovers114310883g_lovers
glozes164313353g_lozes
gnomes93812973g_nomes
gnoses76515163g_noses
gobies95418063g_obies
goboes95914443g_oboes
goes55644093g__o_es
goober93911743g_oober
goobers10219623g_oobers
goodies93516993goodies
goods75124483g_oo_ds
gooey95522863g_oo_ey
goofed114911383g_oofed
goofs94821003g_oo_fs
gooier73516213g_ooier
gooiest82813883g_ooiest
gooks105422883g_oo_ks
gooney106612313g_ooney
gooneys11407073g_ooneys
goonies83618333goonies
goons65326773g_oo_ns
goops86620963g_oo_ps
goos57644913g_oo__s
goose65925903g_oose_
goosed86817033g_oosed
goosey105913513g_oosey
gores65740373g__ores
gorges85321893g_orges
gorses74723293g_orses
gouges86318693g_ouges
goxes135018263g__oxes
graces94523493gr_aces
grades84926313gr_ades
grammes123611323grammes
granges93516523granges
grapes95123123gr_apes
grasses84117343grasses
grates75429893gr_ates
grave94624873gr_ave_
graved114818813gr_aved
gravel105313823gr_avel
gravels113611143gr_avels
graven104513523gr_aven
graver105018593gr_aver
gravers114515273gr_avers
gravest114011633gr_avest
gravies11314093gravies
grazes164519643gr_azes
greases84816713greases
greave104611493greave_
greaved12408913greaved
grebes93813613gr_ebes
grees65132473gr__ees
greiges937733greiges
grides84422363gr_ides
grieve1047243grieve_
grieved1235283grieved
griever1136033griever
grievers1255473grievers
griffes14367923griffes
grilles83715023grilles
grilses8319153grilses
grimes94619033gr_imes
griots74713643grio_ts
gripes94619873gr_ipes
grippes124810373grippes
grivet103517823gr_ivet
grivets11357973gr_ivets
groaned9259973groaned
groaner82510133groaner
groaners9248503groaners
groans74815063gr_oans
groats74816653gr_oats
grocer94212143gr_ocer
grocers103511253grocers
grodier939673grodier
grodiest10310553grodiest
grogs76319413gr_o_gs
groined92710813groined
groins73917203gr_oins
grokked1233673grokked
groks105716123gr_o_ks
grommet12268453grommet
grommets13234663grommets
groom85317983groo__m
grooving13286713grooving
grope84821613gr_ope_
groped107515053gr_oped
groper94517253gr_oper
gropers104813853gropers
gross65421693gr_o_ss
grossed93812253grossed
grosser84313143grosser
grossers94410973grossers
grossest93810093grossest
grosze16457733grosze_
grots65025853gr_o_ts
grottoes9276753grottoes
grottos8337333grottos
grouches14328213grouches
grounds9228313grounds
grouped11419193grouped
grouper104210093grouper
groupers11358643groupers
groupies1137523groupies
groups94210513gr_oups
grouse74315023grouse_
groused94712833groused
grouser84513693grouser
grousers93810733grousers
grouted94111503grouted
grouter84412523grouter
grouters95910083grouters
grouts75015613gr_outs
grower104614933gr_ower
growers113612723growers
growled12278173growled
growler11318973growler
growlers12327093growlers
growls104711113gr_owls
grows95523923gr_o_ws
growths1494423growths
groyne1037213groyne_
grudges10349423grudges
grues65721963gr__ues
grumes94415553gr_umes
grunges93310403grunges
gyves125711553g__yves
hooved134713123_hooved
hoover124314433_hoover
hoovers134312703_hoovers
irones64724013ir_ones
ironies7517423ironies
kroons103711243kroo_ns
loaves94813853_loaves
looies65025833_looies
looses67328243_looses
loves85332013__loves
moves106128423__moves
nooses65623643_nooses
oaves84925613__oaves
oozes145418713__oozes
orgones81010793orgones
orioles7412993orioles
oroides8311973oroides
poove104514303_poove_
probes104119453pr_obes
proles84627203pr_oles
promotes12314123promotes
proofed13138723proofed
proofer12149103proofer
proofers13118363proofers
proofs114511683proo_fs
propones122516963propones
proposes122515973proposes
proses84733473pr_oses
prosses94019513prosses
prove104823193pr_ove_
proved125016033pr_oved
proven114314773pr_oven
prover113819723pr_over
provers123817793pr_overs
provokes1776603provokes
proxies163014933proxies
raves85441973_r_aves
reaves94127573_reaves
reeves94721493_reeves
regroove1243673regroove_
regrooved1443253regrooved
reives95723043_reives
removes124514713removes
rives85336003_r_ives
robes75133303_r_obes
robles85321693_robles
rodes614039083_r_odes
roes45954143_r_o_es
rogues74617673_rogues
roles56747983_r_oles
roods65125283_roo_ds
roofed105214743_roofed
roofer94415283_roofer
roofers105013903_roofers
roofies103014413_roofies
roofs85321153_roo_fs
rooked114918143_rooked
rookies113917103_rookies
rooks95325043_roo_ks
roomed95218543_roomed
roomer84718633_roomer
roomers95416413_roomers
roomies93017243_roomies
rooms75324683_roo_ms
roose56127093_roose_
roosed75621593_roosed
rooser63921883_rooser
roosers74217873_roosers
roosts64916323_roosts
rooted75424003_rooted
rooter64926033_rooter
rooters74522933_rooters
rootles73215633_rootles
roots55933673_roo_ts
ropes75940063_r_opes
roques154912563_roques
roses56445773_r_oses
rotes56143903_r_otes
rottes64524833_rottes
roues56039353_r_oues
rouges76022383_rouges
rouses65436283_rouses
routes66129313_routes
rove75136983_r_ove_
roved95323553_r_oved
roven85521973_r_oven
rover85527373_r_over
rovers95423523_r_overs
scrooges1137163scrooges
shoves124919423_shoves
snoozes16289783snoozes
soaves94218673_soaves
solves95018223_solves
soroses73117483soroses
stooges83611483stooges
stoves93818923_stoves
traves94222743tr_aves
triodes84012503triodes
trioses75015653trioses
troches123715343troches
trokes104019263tr_okes
trompes114111623trompes
trones65629283tr_ones
trooped104010723trooped
trooper94210363trooper
troopers10289443troopers
troops85712783troo_ps
tropes84824353tr_opes
troupes94112853troupes
trove85221923tr_ove_
trover95014663tr_over
trovers103713323tr_overs
vroomed13366433vroomed
vrooms11398713vroo_ms
wolves124510853_wolves

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.406440125.6
2DLD Change Limit1340273656.44020811.6
3Display Results3653650.1402607.1
 (SQL Overall)1786913656.98625578.4
 
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.