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

498 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
groaner8251013(None) 
groaned9259971groaned
groaners9248501groaners
broader103412612broader
browner124911642browner
croaker133010682croaker
crooner93714042crooner
crowner124012602crowner
droner74717672dro_ner
drowner11369802drowner
frowner13429682frowner
gleaner8379772gleaner
gloater83711012gloater
goner66025162g_o_ner
grader84919692gr_ader
grainer83714062grainer
grander93315872gr_ander
granger93514212gr_anger
granter84117132gr_anter
grater74625442gr_ater
graver105018592gr_aver
grayer106014542gr_ayer
grazer164815762gr_azer
greaser83913082greaser
greater84416492greater
greener83111712greener
grinner8329232grinner
groan65618422groan__
groans74815062groan_s
grocer94212142gro_cer
grodier939672grodier
groined92710812groined
groomer10399872groomer
groover11358542groover
groper94517252gro_per
grosser84313142grosser
grounder1047612grounder
grouper104210092grouper
grouser84513692grouser
grouter84412522grouter
grower104614932gro_wer
growler11318972growler
groyne1037212groyne_
groynes1137822groynes
ironer64216452iro_ner
kroner104612572kro_ner
loaner64416502_loaner
moaner84415112_moaner
profaner13197942profaner
roamer84715162_roamer
roarer63914332_roarer
urbaner9177132urbaner
adorner8246983adorner
arcane81216743arcane_
arouser74514423arouser
arranger936873arranger
arrayer10136703arrayer
atoner64817193ato_ner
begroaned13124053begroaned
bloater94013423bloater
boater84622093_boater
boner75133083_bo_ner
borane84620213borane_
boranes93720403boranes
bracer104620583br_acer
brander103915823br_ander
branner94212373branner
braver114719043br_aver
brawer114216333br_awer
brayer115315313br_ayer
brazer174917533br_azer
breaker133912923breaker
briner84519043br_iner
broacher15329263broacher
broaden10289143broaden
broadener1284083broadener
broider103912973broider
broiler92911753broiler
broker124314243bro_ker
bronzer18348493bronzer
brooder103811623brooder
brother123311333brother
browned134710973browned
brownier13226913brownier
browser124911143browser
caner75334773__caner
cleaner93712303cleaner
cloner84418093clo_ner
coaler84121713_coaler
coater84329573_coater
coaxer153912793_coaxer
coiner84323783_coiner
conner84423963_conner
corner84625623_corner
coroner94218203coroner
crane75331603cr_ane_
craned96121653cr_aned
cranes84330753cr_anes
cranker133612783cr_anker
crater85026643cr_ater
craver114618463cr_aver
creamer113714093creamer
creaser94415733creaser
croaked143710533croaked
croakers14288523croakers
croakier14436263croakier
crofter12299573crofter
crone75231333cro_ne_
crones84729243cro_nes
crooker134111093crooker
crooned103813343crooned
crooners103911393crooners
cropper133312963cropper
crosier94116573crosier
crosser95015463crosser
crowder13389863crowder
crower114117563cro_wer
crowned133912433crowned
crowners133710753crowners
crownet123714113crownet
crozer175112843cro_zer
crozier18369933crozier
downer104414923_downer
drainer83012843drainer
draper94315693dr_aper
drawer104711363dr_awer
dreamer104110843dreamer
droller84110283droller
drone65324983dro_ne_
droned84616863dro_ned
droners84114383dro_ners
drones75023433dro_nes
dropper12329873dropper
drover104614593dro_ver
drowned12419903drowned
drowners12428273drowners
eloiner7149183eloiner
eraser64216333er_aser
floater104413353floater
foamer114714313_foamer
forager114412563forager
forayer13368953forayer
framer114817443fr_amer
franker143510183fr_anker
frater94520593fr_ater
fronter103611583fronter
frother133110153frother
frowned14348833frowned
frowners14377933frowners
gager74726293g__ager
gainer74117493g_ainer
gamer84928943g__amer
gander84322763g__ander
gane55145303g__ane_
ganef96322463g__anef
ganev95513863g__anev
ganger83721463g__anger
gaoler73913573gao_ler
gaper86125123g__aper
gardener1037103gardener
garganey1344883garganey
garner73917003g_arner
garotter965943garotter
gater64533653g__ater
gayer94519193g__ayer
gazer155720073g__azer
geomancer1443753geomancer
germander1345363germander
germane1049663germane_
ginner73915823g_inner
glancer103710073g_lancer
glazer164212263g_lazer
gleamer10328513gleamer
gleaned9349423gleaned
gleaners9348073gleaners
gloated93511533gloated
gloaters9288863gloaters
glosser83410813glosser
glover104513533glo_ver
glower105114933glo_wer
gnawer10386953g_nawer
goaded94913713g_oaded
goaled85014363g_oaled
goanna736653g_oanna
goatee73219533g_oatee
goer56827103g_o__er
gofer94814283g_o_fer
goffer13409513g_offer
goiter74116203g_oiter
golder84417603g_older
golfer104411183g_olfer
gomer85220653g_o_mer
gone55639043g_o_ne_
gonef95221293g_o_nef
goners74420173g_o_ners
goober93911743g_oober
goofier11339313goofier
gooier73516213g_ooier
gooney106612313g_ooney
goonier83612843goonier
goopier103910573goopier
goosander1143253goosander
goosier83512563goosier
gopher1239183g_opher
gorger86116983g_orger
gorier73719373g_orier
gorsier83811073gorsier
gouger86014363g_ouger
gowaned1235763gowaned
gowned114410133g_owned
grabber12389763grabber
graben9419723gr_aben
grace85124543gr_ace_
graced105217903gr_aced
graces94523493gr_aces
grade75126093gr_ade_
graded94919553gr_aded
graders94716013gr_aders
grades84926313gr_ades
grafter114211153grafter
grained93814273grained
grainers93012073grainers
grainier9218903grainier
gran56335013gr_an__
grana65722093gr_an_a
granary1157793gr_anary
grand75122693gr_an_d
grandee93115513gr_andee
grandeur10305673gr_andeur
grands84218243gr_ands
grange83716203gr_ange
grangers103011973gr_angers
granges93516523gr_anges
granny104311163gr_anny
grans64832543gr_an_s
grant64840023gr_an_t
granted94715103gr_anted
grantee83217133gr_antee
granters93614143gr_anters
grantor84010933gr_antor
grants73722473gr_ants
granum9310913gr_anum
grape84824663gr_ape_
grapery13457953gr_apery
grapes95123123gr_apes
grapey126012303gr_apey
grapier103712603grapier
grapnel1035603grapnel
grasper10389793grasper
grate64932883gr_ate_
grated84523923gr_ated
graters85419743gr_aters
grates75429893gr_ates
grave94624873gr_ave_
graved114818813gr_aved
gravel105313823gr_avel
graven104513523gr_aven
gravers114515273gr_avers
graves104624003gr_aves
grayed115415643gr_ayed
graze155820053gr_aze_
grazed174115913gr_azed
grazers175112453gr_azers
grazes164519643gr_azes
grazier173611133grazier
grease75416233grease_
greased93812393greased
greasers93410253greasers
greases84816713greases
greasier9298083greasier
greaten83610643greaten
greave104611493greave_
greaved12408913greaved
greaves113311443greaves
greened93111263greened
greenery12265923greenery
greenier938713greenier
greeter82812673greeter
greyer104510093gr_eyer
gridder10367763gridder
griever1136033griever
grifter113810493grifter
griller84513353griller
grimacer1363963grimacer
grimier103210433grimier
grimmer123510093grimmer
grinder93312393grinder
grinned9378553grinned
grinners9288043grinners
griper94114613gr_iper
gripier103210323gripier
gripper124410713gripper
grister83915413grister
gritter83913353gritter
groaning102410283groaning
groat65531973groa__t
groats74816653groa_ts
grocers103511253gro_cers
grocery13336763gro_cery
groggery1433513groggery
groggier1134343groggier
groin65521083groin__
groins73917203groin_s
grokked1233673grokked
grommet12268453grommet
groomed11379503groomed
groomers11388483groomers
groove10438873groove_
grooved12347253grooved
groovers12337123groovers
grooves11368803grooves
groovier1233793groovier
grope84821613gro_pe_
groped107515053gro_ped
gropers104813853gro_pers
gropes95220403gro_pes
grossed93812253grossed
grossers94410973grossers
grosses84517683grosses
grosze16457733grosze_
grottier9316673grottier
ground82310273groun_d
grounded1136573grounded
grounders1156783grounders
grounds9228313grounds
grouped11419193grouped
groupers11358643groupers
grouse74315023grouse_
groused94712833groused
grousers93810733grousers
grouses84616543grouses
grouted94111503grouted
grouters95910083grouters
groutier9297173groutier
grove95219333gro_ve_
groved114413703gro_ved
grovel104310543gro_vel
groveler12305843groveler
groves104318103gro_ves
growers113612723gro_wers
growled12278173growled
growlers12327093growlers
growlier1234883growlier
grown95317353grown__
grownup1342213grownup
grubber12417913grubber
grudger10368313grudger
grueler837023grueler
gruffer1475793gruffer
grummer12338783grummer
grunger9389783grunger
grunter83110783grunter
gunner73813983g_unner
hoaxer16348563_hoaxer
honer85332093_ho_ner
humaner12257663humaner
inaner62213543_inaner
insaner7310443insaner
irater65218353ir_ater
irone55126363iro_ne_
ironed74916013iro_ned
ironers74813553iro_ners
irones64724013iro_nes
joiner134114133_joiner
krater104014313kr_ater
krone94018733kro_ne_
kronen10348913kro_nen
kronor10417233kro_nor
kronur10415313kro_nur
leaner64022193_leaner
loader74316313_loader
loafer93610943_loafer
loaned73816293_loaned
loaners73913623_loaners
loner55431043_lo_ner
loriner7511893loriner
meaner84617843_meaner
moaned94514173_moaned
moaners92813553_moaners
mooner85317833_mooner
oater55433733__oater
ordainer945223ordainer
owner84613313__owner
planer84122653_planer
prancer113613383pr_ancer
prater84825353pr_ater
prawner1246803prawner
prayer114815293pr_ayer
preaver121011613preaver
preener93114833preener
prober104516073pro_ber
prodder1147953prodder
profane122111863profane_
profaned14207973profaned
profaners14256213profaners
profanes132311573profanes
proffer15126933proffer
progger11319373progger
prone75332623pro_ne_
proofer12149103proofer
propane112716153propane_
propanes122415823propanes
proper104319953pro_per
proser84223463pro_ser
prosier93817483prosier
prosper114012193prosper
prouder10310383prouder
prover113819723pro_ver
prower114218123pro_wer
prowler123310013prowler
pruner83413453pr_uner
racer75233023_r_acer
raker94529793_r_aker
ranee55438103_r_anee
ranger73925523_r_anger
ranker105021903_r_anker
ranter63826823_r_anter
raper74932753_r_aper
rarer54731703_r_arer
raser55633413_r_aser
rater54943283_r_ater
raver85631493_r_aver
rawer84623733_r_awer
razer144824273_r_azer
reader73628293_reader
realer63528593_realer
reamer84325213_reamer
reaper84223143_reaper
rearer64928913_rearer
reaver94524733_reaver
roadeo7510323_roadeo
roamed95215093_roamed
roamers93713463_roamers
roan47234203_roan__
roans54926443_roan_s
roar46328573_roa__r
roared75015393_roared
roarers73812743_roarers
roaster74116663_roaster
robber103916533_robber
rocker124319573_rocker
roger64521413_ro_ger
rolfer94412273_rolfer
roller63919793_roller
romancer1247293_romancer
romper104213683_romper
ronnel63310883_ronnel
roofer94415283_roofer
roomer84718633_roomer
rooser63921883_rooser
rooter64926033_rooter
roper75431913_ro_per
ropier84118803_ropier
rosier64221263_rosier
roster64329083_roster
rotter64325463_rotter
rounder83514603_rounder
rouser65224083_rouser
router65025843_router
rover85527373_ro_ver
rower85430493_ro_wer
rozzer1437353_rozzer
ruiner64013643_ruiner
runner63814463_runner
saner54334323__saner
scorner9259763scorner
shoaler102610083shoaler
soaker105717533_soaker
soaper84517873_soaper
soarer64522243_soarer
sooner64220463_sooner
sorner64720393_sorner
stoner65823203sto_ner
swooner10358673swooner
toner55336243_to_ner
tonner64819203_tonner
tracer84820233tr_acer
trader75218763tr_ader
trainer73316793trainer
treader84113833treader
treater74219833treater
troaked12438253troaked
troffer13125863troffer
troller73913173troller
trone55131863tro_ne_
trones65629283tro_nes
trooper94210363trooper
trotter73312253trotter
trouncer1035443trouncer
trouper93811433trouper
trouser73812473trouser
trover95014663tro_ver
urbane82211383urbane_
weaner93816773_weaner
wonner95114443_wonner
wreaker143610043wreaker
wronger11288823wronger
zoner144520343_zo_ner

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.410435831.7
2DLD Change Limit1340274986.50020619.5
3Display Results4984980.1702929.4
 (SQL Overall)1786914987.08025238.8
 
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.