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

223 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
grocery1333676(None) 
grocer94212141grocer_
grocers103511251grocers
crockery19356602crockery
grapery13457952grapery
groggery1433512groggery
groper94517252groper_
gropers104813852gropers
grower104614932grower_
growers113612722growers
rockery16439252_rockery
ropery114313872_ropery
rosery93813282_rosery
sorcery1237032sorcery
tracery12399792tracery
archery15478063archery
artery9911453ar_tery
bootery1238983bootery
bowery146012113_bowery
bracer104620583bracer_
bracero11428743bracero
bracers114616703bracers
bravery15428133bravery
brewery15376963brewery
bribery14426493bribery
briery114510773br_iery
broguery1443313broguery
broidery14356083broidery
broker124314243broker_
brokers133111913brokers
clovery15407403clovery
cookery164210393cookery
coopery143910273coopery
crocein1138073crocein
crookery17415993crookery
crower114117563crower_
crowers124614903crowers
crozer175112843crozer_
crozers184111083crozers
dowery134311663_dowery
drapery13387943drapery
drollery12314793drollery
droner74717673droner_
droners84114383droners
drosera836203drosera
drover104614593drover_
drovers115212643drovers
erosely1038083erosely
flowery16327783flowery
foolery1336693foolery
forcer114917343forcer_
forcers124215713forcers
forgery14419303forgery
gallery11468743gallery
gaoler73913573gaoler_
gaolers83511563gaolers
gaudery1234743gaudery
geodesy1233133geodesy
geometry1445393geometry
gingery12368913gingery
glomera1035943glomera
glory96413293glo__ry
glover104513533glover_
glovers114310883glovers
glower105114933glower_
glowers113412093glowers
glyceryl1741943glyceryl
goer56827103g_o_er_
goers65520253g_o_ers
gofer94814283g_ofer_
gofers104711513g_ofers
gomer85220653g_omer_
gomers94116883g_omers
goner66025163g_oner_
goners74420173g_oners
goober93911743goober_
goobers10219623goobers
gooey95522863g_ooe_y
gooier73516213gooier_
gooney106612313goone_y
goosey105913513goose_y
gorger86116983gorger_
gorgers94813643gorgers
gorier73719373gorier_
gory86129663g_o__ry
govern1036823g_overn
grace85124543grace__
graced105217903grace_d
graces94523493grace_s
grader84919693grader_
graders94716013graders
gramary1355903gramary
gramercy1641923gramercy
granary1157793granary
grapey126012303grape_y
grater74625443grater_
graters85419743graters
gravely14469063gravely
graver105018593graver_
gravers114515273gravers
grayer106014543grayer_
grazer164815763grazer_
grazers175112453grazers
greedy11518853gr_eedy
greenery12265923greenery
greeny104811453gr_eeny
grey85624043gr__e_y
greyer104510093greyer_
grillery12355503grillery
grindery13255513grindery
griper94114613griper_
gripers104011463gripers
gripey124111203gripe_y
groaner82510133groaner_
groaners9248503groaners
groceries1249503groceries
grodier939673grodier_
grody103412063gro__dy
groggy1234803gro_ggy
groomer10399873groomer_
groomers11388483groomers
groover11358543groover_
groovers12337123groovers
groovy13375403gro_ovy
grope84821613grope__
groped107515053grope_d
gropes95220403grope_s
grosser84313143grosser_
grossers94410973grossers
grossly1175983grossly
groszy19395703gro_szy
grotty10389833gro_tty
grouchy16294243grouchy
grouper104210093grouper_
groupers11358643groupers
grouser84513693grouser_
grousers93810733grousers
grouter84412523grouter_
grouters95910083grouters
grouty104710983gro_uty
grove95219333grove__
groved114413703grove_d
grovel104310543grove_l
grovels11427813grovels
groves104318103grove_s
growler11318973growler_
growlers12327093growlers
growly13499173gro_wly
growthy1773283growthy
gruyere1133123gruyere
gunnery11376373gunnery
guttery11427763guttery
ironer64216453ironer_
ironers74813553ironers
kroner104612573kroner_
lowery124112713_lowery
mercery14397623mercery
mockery18376913_mockery
mopery135210973_mopery
ochery14319443__ochery
ochry13346933__ochry
onery8414123__onery
ornery938463or_nery
orogeny11107023orogeny
orrery936783or_rery
popery134511703_popery
pricer103918293pricer_
pricers113915063pricers
pricey134412633price_y
prober104516073prober_
probers113514583probers
procarp1346823procarp
proceed12310553proceed
process11310403process
procure1138573procure
progeny1389463progeny
pronely12310253pronely
proper104319953proper_
properly1546463properly
propers113619033propers
property1547073property
proser84223463proser_
prosers94219643prosers
prover113819723prover_
proverb14378213proverb
provers123817793provers
prower114218123prower_
prudery1335243prudery
racer75233023_racer_
racers84725433_racers
revery124014213_revery
ricer74726613_ricer_
ricers84120993_ricers
robbery14348283_robbery
rocker124319573_rocker_
rockers133916553_rockers
rocketry1744503_rocketry
rocky144513853_roc_ky
roger64521413_roger_
rogers74517913_rogers
roguery1134893_roguery
rookery14398313rookery
roper75431913_roper_
ropers84325903_ropers
ropey106021873_rope_y
rosary92810353_rosary
rotary92411303_rotary
rover85527373_rover_
rovers95423523_rovers
rower85430493_rower_
rowers94924573_rowers
rudery10419033_rudery
showery16437243showery
spicery14499013spicery
towery124012093_towery
tracer84820233tracer_
tracers94917843tracers
trickery17297343trickery
trocar848773trocar_
trocars959043trocars
trover95014663trover_
trovers103713323trovers
volery1237873_volery

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.440406115.9
2DLD Change Limit1340272237.31018334.7
3Display Results2232230.0802787.5
 (SQL Overall)1786912237.83022821.3
 
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.