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

374 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
groaners924850(None) 
groaner82510131groaner_
croakers14288522croakers
crooners103911392crooners
crowners133710742crowners
droners84114382dro_ners
drowners12428272drowners
frowners14377932frowners
gleaners9348072gleaners
gloaters9288862gloaters
goners74420172g_o_ners
graders94716012gr_aders
grainers93012072grainers
grangers103011972gr_angers
granters93614142gr_anters
graters85419742gr_aters
gravers114515272gr_avers
grazers175112452gr_azers
greasers93410252greasers
grinners9288042grinners
groaned9259972groane_d
groans74815062groan__s
grocers103511252gro_cers
groomers11388482groomers
groovers12337122groovers
gropers104813852gro_pers
grossers94410972grossers
grounders1156782grounders
groupers11358642groupers
grousers93810732grousers
grouters95910082grouters
growers113612722gro_wers
growlers12327092growlers
groynes1137822groyne_s
ironers74813552iro_ners
loaners73913622_loaners
moaners92813552_moaners
profaners14256212profaners
roamers93713462_roamers
roarers73812742_roarers
adorners9196623adorners
arousers84810983arousers
arrangers1045813arrangers
arrayers11125853arrayers
atoners75013953ato_ners
bloaters103311023bloaters
boaters93419243_boaters
boners84825433_bo_ners
boranes93720403borane_s
bracers114616703br_acers
branders114313093br_anders
branners104010923branners
bravers124715523br_avers
brayers124511903br_ayers
brazers184513943br_azers
breakers143810973breakers
briners94315633br_iners
broachers16328153broachers
broadeners1383653broadeners
broadens11267243broadens
broader103412613broader_
broadness1256663broadness
broiders114211193broiders
broilers103210093broilers
brokers133111913bro_kers
bronzers19296983bronzers
brooders112610243brooders
brothers133410833brothers
browner124911643browner_
browsers13449203browsers
caners84629203__caners
cleaners103610543cleaners
cloners94514823clo_ners
coalers94419353_coalers
coaters93525793_coaters
coaxers164311083_coaxers
coiners93620753_coiners
conners94023113_conners
corners94723313_corners
coroners104016223coroners
cranes84330753cr_ane_s
craters95021893cr_aters
cravers124416553cr_avers
creamers124111303creamers
creasers103612823creasers
croaker133010683croaker_
crofters13358903crofters
crones84729243cro_ne_s
crooner93714043crooner_
croppers143311483croppers
crosiers103312063crosiers
crossers103912703crossers
crowders14398803crowders
crowers124614893cro_wers
crowner124012593crowner_
crownets13407673crownets
crozers184111083cro_zers
croziers19287003croziers
downers113912773_downers
drainers92811253drainers
drapers105313353dr_apers
drawers113610073dr_awers
dreamers11369003dreamers
droner74717673dro_ner_
drones75023433dro_ne_s
droppers13318603droppers
drovers115212643dro_vers
drowner11369803drowner_
eloiners8128153eloiners
erasers74413943er_asers
floaters112711513floaters
foamers123812103_foamers
foragers12349633foragers
forayers14277273forayers
framers125113823fr_amers
frankers15348353fr_ankers
fraters103517213fr_aters
frothers14279813frothers
frowner13429683frowner_
gagers84021333g__agers
gainers84214593g_ainers
gamers94420833g__amers
ganders93521703g__anders
ganefs10489203g__anefs
ganevs10456913g__anevs
gangers94418603g__angers
gaolers83511563gao_lers
gapers94520473g__apers
gardeners1136603gardeners
garganeys1442613garganeys
garners83815983g_arners
garotters1055033garotters
gaters74728643g__aters
gazers164516303g__azers
geomancers1542953geomancers
germanders1444603germanders
ginners84314223g_inners
glancers11408003g_lancers
glanders103811503g_landers
glazers174410043g_lazers
gleamers11306563gleamers
gleaner8379773gleaner_
gloater83711013gloater_
glossers9319053glossers
glovers114310883glo_vers
glowers113412093glo_wers
gnawers11356393g_nawers
goannas836223g_oannas
goatees82710443g_oatees
goers65520253g_o__ers
gofers104711513g_o_fers
goffers14409213g_offers
goiters84014443g_oiters
golfers114410083g_olfers
gomers94116883g_o_mers
gonefs10439873g_o_nefs
goner66025163g_o_ner_
goobers10219623g_oobers
goodness1036253goodness
gooneys11407073g_ooneys
goosanders1242863goosanders
gophers1338983g_ophers
gorgers94813643g_orgers
goriness9310753goriness
gougers94911763g_ougers
grabbers13337883grabbers
grabens10367003gr_abens
graces94523493gr_ace_s
grader84919693gr_ader_
grades84926313gr_ade_s
grafters12409193grafters
grainer83714063grainer_
granary1157793gr_anary
grandees103211283gr_andees
grander93315873gr_ander_
grandeurs11335113gr_andeurs
grands84218243gr_an_ds
granger93514213gr_anger_
granges93516523gr_anges
grans64832543gr_an__s
grantees92510973gr_antees
granter84117133gr_anter_
grantors93810353gr_antors
grants73722473gr_an_ts
grapery13457953gr_apery
grapes95123123gr_ape_s
grapnels1134393grapnels
graspers11338403graspers
grater74625443gr_ater_
grates75429893gr_ate_s
gravels113611143gr_avels
graver105018593gr_aver_
graves104624003gr_ave_s
grayer106014543gr_ayer_
grayness1235933grayness
grazer164815763gr_azer_
grazes164519643gr_aze_s
graziers18387123graziers
greaser83913083greaser_
greases84816713grease_s
greatens9307593greatens
greater84416493greater_
greatness1036903greatness
greaves113311443greave_s
greener83111713greener_
greenery12265923greenery
greeters92610113greeters
greyness1235243greyness
gridders11286293gridders
grievers1255473grievers
grifters12389233grifters
grillers93810813grillers
grimacers1463553grimacers
grimness1175993grimness
grinders103410423grinders
grinner8329233grinner_
gripers104011463gr_ipers
grippers13358133grippers
gristers94013403gristers
gritters94210633gritters
groan65618423groan___
groaning102410283groaning
groats74816653groa__ts
grocer94212143gro_cer_
grocery13336763gro_cery
grodier939673grodier_
groggery1433513groggery
groined92710813groine_d
groins73917203groin__s
grommets13234663grommets
groomer10399873groomer_
groover11358543groover_
grooves11368803groove_s
groper94517253gro_per_
gropes95220403gro_pe_s
grosser84313143grosser_
grosses84517683grosse_s
grossness1045963grossness
grounder1047613grounder_
grounds9228313groun_ds
grouper104210093grouper_
grouser84513693grouser_
grouses84616543grouse_s
grouter84412523grouter_
grovelers13305163grovelers
grovels11427813gro_vels
groves104318103gro_ve_s
grower104614933gro_wer_
growler11318973growler_
grownups1441503grownups
groyne1037213groyne__
grubbers13316203grubbers
grudgers11266753grudgers
gruelers936173gruelers
grungers10298503grungers
grunters9359033grunters
gunners83111733g_unners
hoaxers17327133_hoaxers
honers94324973_ho_ners
ironer64216453iro_ner_
irones64724013iro_ne_s
ironness836953ironness
joiners144211573_joiners
kraters114212343kr_aters
kroner104612573kro_ner_
leaners73718173_leaners
loaders83413433_loaders
loafers10349463_loafers
loaner64416503_loaner_
loners64225813_lo_ners
loriners839963loriners
meaners94415243_meaners
moaner84415113_moaner_
mooners94015343_mooners
oaters65029793__oaters
ordainers1055113ordainers
owners94210703__owners
planers94517943_planers
prancers123210333pr_ancers
praters94921653pr_aters
prawners1346003prawners
prayers124212853pr_ayers
preavers13910263preavers
preeners102712813preeners
probers113514583pro_bers
prodders1237463prodders
profaner13197943profaner_
profanes132311573profane_s
proffers16126593proffers
proggers12258163proggers
proofers13118363proofers
propanes122415823propane_s
propers113619033pro_pers
prosers94219643pro_sers
prospers123012263prospers
provers123817793pro_vers
prowlers13328933prowlers
pruners93710723pr_uners
racers84725433_r_acers
rakers104123573_r_akers
ranees64623963_r_anees
rangers83621043_r_angers
rankers113217463_r_ankers
ranters73323643_r_anters
rapers84327183_r_apers
rasers64526783_r_asers
raters63936583_r_aters
ravers94628183_r_avers
razers154919613_r_azers
readers83823773_readers
reamers94221083_reamers
reapers93520453_reapers
rearers74323563_rearers
reavers108320743_reavers
roadeos837413_roadeos
roamer84715163_roamer_
roans54926443_roan__s
roarer63914333_roarer_
roars55622243_roa__rs
roasters83615933_roasters
robbers112814163_robbers
rockers133916553_rockers
rogers74517913_ro_gers
rolfers104011813_rolfers
rollers73117473_rollers
romancers1345733_romancers
rompers113412243_rompers
ronnels7318613_ronnels
roofers105013903_roofers
roomers95416413_roomers
roosers74217873_roosers
rooters74522933_rooters
ropers84325903_ro_pers
rosters73727543_rosters
rotters74421393_rotters
rounders92613693_rounders
rousers75220143_rousers
routers74822873_routers
rovers95423523_ro_vers
rowers94924573_ro_wers
rozzers1535633_rozzers
ruiners74213023_ruiners
runners74212453_runners
scorners10228493scorners
soakers114114953_soakers
soapers93715923_soapers
soarers74118093_soarers
sooners73916643_sooners
sorners73416873_sorners
stoners74817953sto_ners
swooners11336863swooners
toners64128003_to_ners
tonners73816403_tonners
tracers94917843tr_acers
traders84316953tr_aders
trainers83114643trainers
treaders93311843treaders
treaters83615843treaters
troffers14125433troffers
trollers83211213trollers
trones65629283tro_ne_s
troopers10289443troopers
trotters83310243trotters
trouncers1134803trouncers
troupers10359443troupers
trousers83910633trousers
trovers103713323tro_vers
trowsers11428003trowsers
urbaner9177133urbaner_
weaners104613833_weaners
wonners104312813_wonners
wreakers15328423wreakers
wrongers12327773wrongers
zoners155115993_zo_ners

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461623747.80018738.7
3Display Results3743740.1402671.4
 (SQL Overall)1786913748.09622071.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.