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

396 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
groover1135854(None) 
groomer10399871groomer
groove10438871groove_
grooved12347251grooved
groovers12337121groovers
grooves11368801grooves
groovier1233791groovier
brooder103811622brooder
crooker134111092crooker
crooner93714042crooner
drover104614592dr_over
glover104513532g_lover
goober93911742g_oober
gooier73516212g_ooier
graver105018592gr_aver
griever1136032griever
groaner82510132groaner
grocer94212142gr_ocer
grodier939672grodier
groomed11379502groomed
groomers11388482groomers
groovy13375402groov_y
groper94517252gr_oper
grosser84313142grosser
grouper104210092grouper
grouser84513692grouser
grouter84412522grouter
grove95219332gr_ove_
groved114413702gr_oved
grovel104310542gr_ovel
groves104318102gr_oves
grower104614932gr_ower
growler11318972growler
hoover124314432_hoover
proofer12149102proofer
prover113819722pr_over
roofer94415282_roofer
roomer84718632_roomer
rooser63921882_rooser
rooter64926032_rooter
rover85527372_r_over
trooper94210352trooper
trover95014662tr_over
allover1038583allover
armorer9259903armorer
arouser74514423arouser
arriver10117793arriver
bloomer11419813bloomer
blooper11358533blooper
booger94816553_booger
booker124719193_booker
boomer104618513_boomer
boozer174815963_boozer
braver114719043br_aver
broader103412603broader
broider103912973broider
broiler92911753broiler
broker124314243br_oker
bronzer18348493bronzer
brooded113510933brooded
brooders112610233brooders
broodier1157433broodier
brooked143610033brooked
broomed124111053broomed
broomier1236873broomier
brother123311333brother
browner124911643browner
browser124911143browser
chooser124412963chooser
clover114617123_clover
cooer74831013_coo_er
cooker124722453_cooker
cooler84824713_cooler
cooper104221123_cooper
cooter85128613_cooter
coroner94218203coroner
cover105430773__cover
craver114618463cr_aver
croaker133010683croaker
crofter12299573crofter
crooked143910943crooked
crookery17415993crookery
crooned103813343crooned
crooners103911393crooners
cropper133312963cropper
crosier94116573crosier
crosser95015463crosser
crossover1484313crossover
crowder13389843crowder
crower114117553cr_ower
crowner124012593crowner
crozer175112843cr_ozer
crozier18369933crozier
cutover1235283cutover
doozer163910463_doozer
driver104714493dr_iver
droller84110283droller
droner74717673dr_oner
drooled9369203drooled
droolier936073droolier
drooped11368433drooped
droopier1145573droopier
dropper12329873dropper
drove95518063dr_ove_
droved114611643dr_oved
drovers115212643dr_overs
droves105116673dr_oves
drowner11369803drowner
evolver13275803evolver
flooder11258463flooder
floorer10248073floorer
flopover1642863flopover
flyover1633513flyover
footer94320773_footer
forever1338953forever
fronter103611583fronter
frother133110153frother
frowner13429683frowner
gaoler73913573g_aoler
garotter965943garotter
garroter956573garroter
geologer1044483geologer
giver94921203g__iver
gloater83711013gloater
gloomed11337413gloomed
gloomier1135093gloomier
glosser83410813glosser
glove94516293g_love_
gloved114811873g_loved
glovers114310883g_lovers
gloves104115183g_loves
glower105114933g_lower
goer56827103g__o_er
gofer94814283g__ofer
goffer13409513g_offer
goiter74116203g_oiter
golder84417603g_older
golfer104411183g_olfer
gomer85220653g__omer
goner66025163g__oner
goobers10219623g_oobers
gooey95522863g_oo_ey
goofed114911383g_oofed
goofier11339313goofier
gooney106612313g_ooney
goonier83612843goonier
goopier103910573goopier
goose65925903g_oose_
goosed86817033g_oosed
gooses75723053g_ooses
goosey105913513g_oosey
goosier83512563goosier
gopher1239183g_opher
gorger86116983g_orger
gorier73719373g_orier
gorsier83811073gorsier
gouger86014363g_ouger
govern1036823g__overn
grabber12389763grabber
grader84919693gr_ader
grafter114211153grafter
grainer83714063grainer
grander93315873grander
granger93514213granger
granter84117133granter
grapier103712603grapier
grasper10389783grasper
grater74625433gr_ater
grave94624873gr_ave_
graved114818813gr_aved
gravel105313823gr_avel
graven104513523gr_aven
gravers114515263gr_avers
graves104624003gr_aves
grayer106014543gr_ayer
grazer164815763gr_azer
grazier173611133grazier
greaser83913083greaser
greater84416493greater
greave104611493greave_
greaved12408913greaved
greaves113311443greaves
greener83111713greener
greeter82812673greeter
greyer104510093gr_eyer
gridder10367763gridder
grieve1047243grieve_
grieved1235283grieved
grievers1255473grievers
grieves1137323grieves
grifter113810493grifter
griller84513353griller
grimier103210433grimier
grimmer123510093grimmer
grinder93312393grinder
grinner8329233grinner
griper94114613gr_iper
gripier103210323gripier
gripper124410713gripper
grister83915413grister
gritter83913353gritter
grivet103517823gr_ivet
groaned9259973groaned
groaners9248493groaners
grocers103511253gr_ocers
grocery13336763gr_ocery
groggery1433513groggery
groggier1134343groggier
groined92710813groined
grokked1233673grokked
grommet12268453grommet
groom85317983groo__m
grooms94512523groo_ms
grooviest1334083grooviest
grooving13286713grooving
grope84821613gr_ope_
groped107515053gr_oped
gropers104813853gr_opers
gropes95220403gr_opes
grossed93812253grossed
grossers94410973grossers
grosses84517683grosses
grosze16457733grosze_
grottier9316673grottier
grounder1047603grounder
grouped11419193grouped
groupers11358633groupers
grouse74315023grouse_
groused94712833groused
grousers93810723grousers
grouses84616543grouses
grouted94111503grouted
grouters95910063grouters
groutier9297173groutier
groveler12305843groveler
grovels11427813gr_ovels
growers113612723gr_owers
growled12278163growled
growlers12327093growlers
growlier1234883growlier
groyne1037213groyne_
groynes1137823groynes
grubber12417913grubber
grudger10368313grudger
grueler837023grueler
gruffer1475793gruffer
grummer12338783grummer
grunger9389783grunger
grunter83110783grunter
hoofer124014953_hoofer
hooker134820173_hooker
hooper114518313_hooper
hooter94123923_hooter
hooved134713123_hooved
hoovers134312703_hoovers
hooves124815483_hooves
hover115524133__hover
ironer64216453ir_oner
kroner104612573kr_oner
layover1334433layover
looker104816953_looker
looper83817113_looper
looser65219943_looser
looter64222323_looter
louver94110393_louver
lover85526453__lover
mooner85317833_mooner
mooter83921093_mooter
moreover1344863moreover
mover104220863__mover
nooser65517823_nooser
over77227343___over
plover115312613_plover
pooler83819843_pooler
poorer82613993_poorer
poove104514303_poove_
pooves113914713_pooves
popover1495843popover
preaver121011613preaver
prober104516073pr_ober
prodder1147953prodder
proffer15126933proffer
progger11319373progger
promoter12311453promoter
proofed13138723proofed
proofers13118363proofers
proper104319953pr_oper
proposer121810633proposer
proser84223463pr_oser
prosier93817483prosier
prosper114012183prosper
prouder10310373prouder
prove104823193pr_ove_
proved125016033pr_oved
proven114314773pr_oven
proverb14378213pr_overb
provers123817793pr_overs
proves114322253pr_oves
provoker1784913provoker
prower114218123pr_ower
prowler123310013prowler
raver85631493_r_aver
reaver94524733_reaver
recover124312623recover
regroove1243673regroove_
regrooved1443253regrooved
regrooves1343863regrooves
reiver95318293_reiver
remover124612273remover
riever94811653_riever
rioter64817283_rioter
river85731693_r_iver
roamer84715163_roamer
roarer63914333_roarer
robber103916533_robber
rocker124319573_rocker
roger64521413_r_oger
rolfer94412273_rolfer
roller63919793_roller
rollover1144453_rollover
romper104213683_romper
roofed105214743_roofed
roofers105013903_roofers
rooked114918143_rooked
rookery14398313_rookery
rookier114012383_rookier
roomed95218543_roomed
roomers95416413_roomers
roomier93812243_roomier
roose56127093_roose_
roosed75621593_roosed
roosers74217873_roosers
rooses65526233_rooses
rooster74415173_rooster
rooted75424003_rooted
rooters74522933_rooters
rootier74915393_rootier
roper75431913_r_oper
ropier84118803_ropier
rosier64221263_rosier
roster64329083_roster
rotter64325463_rotter
rouser65224083_rouser
router65025843_router
rove75136983_r_ove_
roved95323553_r_oved
roven85521973_r_oven
rovers95423523_r_overs
roves84834483_r_oves
rower85430493_r_ower
rozzer1437353_rozzer
runover1034663runover
scooper113812033scooper
scooter93312863scooter
shooter103013973shooter
shover124515983_shover
snooker113910303snooker
snooper93511533snooper
snoozer16409183snoozer
soever94412093_soever
solver94016703_solver
sooner64220463_sooner
spoofer12368723spoofer
spooler93711383spooler
stooker113811733stooker
stooper93813183stooper
stopover1344063stopover
stover94115643_stover
swooner10358673swooner
swooper12389173swooper
tooler63818613_tooler
tooter64420803_tooter
troffer13125863troffer
troller73913173troller
trooped104010723trooped
troopers10289423troopers
trotter73312253trotter
trouper93811413trouper
trouser73812463trouser
trouvere1144053trouvere
trouveur1141663trouveur
trove85221923tr_ove_
trovers103713313tr_overs
troves94719113tr_oves
turnover1143593turnover
uncover1239003uncover
uprooter1085243uprooter
vroomed13366433vroomed
whoever1634103whoever
whooper15297153whooper
wolver12419713_wolver
wooer84316693_woo_er
woofer124411363_woofer
wooler93615873_wooler
wronger11288823wronger
zooier153411233_zooier

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340273968.17316398.8
3Display Results3963960.1402828.6
 (SQL Overall)1786913968.46921099.4
 
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.