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

118 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
groggery143351(None) 
broguery1443312broguery
doggery13448262_doggery
grocery13336762gro_cery
groggier1134342groggier_
groggily1443282groggily
groggy1234802grogg__y
priggery1543992priggery
progger11319372progger_
proggers12258162proggers
roguery1134892_roguery
toggery12505922_toggery
blogger11448313blogger_
bloggers12397403bloggers
bragger113810043bragger_
braggers12327903braggers
broidery14356083broidery
buggery14367933_buggery
clogger11438803clogger_
cloggers12437283cloggers
crockery19356603crockery
crookery17415993crookery
dodgery13627783_dodgery
dogger95216783_dogger_
doggers104413433_doggers
dragger10309173dragger_
draggers11357393draggers
drollery12314793drollery
drudgery14273633drudgery
flogger12449463flogger_
floggers13387863floggers
fogger114414783_fogger_
foggers124112013_foggers
forgery14419303_forgery
frogged13408493frogge_d
froggier1354643froggier_
froggy1434493frogg__y
gagger95016513g_agger_
gaggers103413663g_aggers
gingery12368913g_ingery
goggler10379323g_oggler_
gogglers11276713g_ogglers
goggly12337053g_ogg_ly
gorger86116983g_orger_
gorgers94813643g_orgers
gouger86014363g_ouger_
gougers94911763g_ougers
granger93514213granger_
grangers103011973grangers
grapery13457953gr_apery
greenery12265923greenery
grillery12355503grillery
grindery13255513grindery
groaner82510133groaner_
groaners9248503groaners
grocer94212143gro_cer_
grocers103511253gro_cers
grodier939673grodier_
groggeries1354703groggeries
groggiest1235093groggiest
groomer10399873groomer_
groomers11388483groomers
groover11358543groover_
groovers12337123groovers
groper94517253gro_per_
gropers104813853gro_pers
grosser84313143grosser_
grossers94410973grossers
grouper104210093grouper_
groupers11358643groupers
grouser84513693grouser_
grousers93810733grousers
grouter84412523grouter_
grouters95910083grouters
grower104614933gro_wer_
growers113612723gro_wers
growler11318973growler_
growlers12327093growlers
grudger10368313grudger_
grudgers11266753grudgers
grunger9389783grunger_
grungers10298503grungers
hogger114615083_hogger_
hoggers124512483_hoggers
jaggery19336903_jaggery
jogger154713163_jogger_
joggers164110693_joggers
logger86420003_logger_
loggers94616133_loggers
orangery12305543orangery
orogeny11107023oro_geny
piggery14266193_piggery
preggers12236833preggers
progeny1389463pro_geny
progged12409803progge_d
raggedy13334663_raggedy
rigger85616713_rigger_
riggers93613843_riggers
robbery14348283_robbery
rockery16439253_rockery
roger64521413_ro_ger_
rogers74517913_ro_gers
rookery14398313_rookery
ropery114313873_ro_pery
rosery93813283_ro_sery
rugger84414513_rugger_
ruggers94612313_ruggers
slogger94310483slogger_
sloggers10418783sloggers
snuggery13253973snuggery
staggery13346243staggery
thuggery1642563thuggery
trigger9329163trigger_
triggers10257843triggers
waggery15276903_waggery
wiggery15295873_wiggery
wronger11288823wronger_
wrongers12327773wrongers

Search took 7 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.420425454.8
2DLD Change Limit1461621186.48622535.0
3Display Results1181180.0462565.2
 (SQL Overall)1786911186.95225703.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.