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 “grogs” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

165 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
grogs7631941(None) 
frogs96220771frogs
grigs75318191grigs
grog65923341grog_
groks105716121groks
gross65421691gross
grots65025851grots
grows95523921grows
progs86624151progs
trogs67022601trogs
biogs85016112biogs
blogs85319232blogs
bogs75742752_bogs
brags85625102brags
brigs85823222brigs
broos75126412broos
bros65635662bro_s
brows105425982brows
clogs85519552clogs
cogs77340032_cogs
crags85622572crags
crocs95722432crocs
crops96125242crops
cross75124502cross
crows105727312crows
dogs66440152_dogs
drags75521112drags
dregs76114862dregs
drops85719502drops
dross65418092dross
drugs75214652drugs
ergs55523812er_gs
eros45238452ero_s
flogs95919962flogs
fogs87035002_fogs
frags96322172frags
frigs96019272frigs
froes86126692froes
frog85624362frog_
frons86124042frons
frows116623102frows
frugs96114282frugs
gags66441062g_ags
gangs76222582gangs
gaols66717572gaols
gigs66631182g_igs
girons75014372girons
giros65722652giro_s
globs85616402globs
glogg837352glogg
gloggs935032gloggs
gloms85219782gloms
glops85619552glops
gloss64319622gloss
glows95518032glows
glugs75214282glugs
goas55239942g_oas
gobs76935572g_obs
gods65438042g_ods
goes55644092g_oes
gogo69722832g_ogo
gogos77516522g_ogos
gongs74921612gongs
goods75124482goods
goofs94821002goofs
gooks105422882gooks
goons65326772goons
goops86620962goops
goos57644912g_oos
gores65740372gores
gorge76423892gorge
gorges85321892gorges
gorms85619592gorms
gorps85316992gorps
gos47155132g_o_s
goys86328412g_oys
grabs85719692grabs
grads75625752grads
grams85327312grams
grans64832542grans
grass66125202grass
grays95621332grays
grees65132472grees
grego7310522grego
gregos847532gregos
greys96614852greys
grids75321392grids
grig65424772grig_
grins65427222grins
griots74713642griots
grips85520132grips
grits65529582grits
groan65618422groan
groans74815062groans
groat65531972groat
groats74816652groats
grody103412062grody
groggy1234802groggy
groin65521082groin
groins73917202groins
grok95819682gro_k
groom85317982groom
grooms94512522grooms
grope84821612grope
gropes95220402gropes
grosz154814092grosz
grot55942052gro_t
group85413922group
groups94210512groups
grouse74315022grouse
grout65330422grout
grouts75015612grouts
grove95219332grove
groves104318102groves
grow86127302gro_w
growl96115822growl
growls104711112growls
grown95317352grown
grubs86312602grubs
grues65721962grues
gyrons105511222gyrons
gyros95616482gyro_s
hogs87139662_hogs
irons55324132irons
jogs127129332_jogs
logs57343112_logs
mogs75439332_mogs
nogs56534612_nogs
prigs85219702prigs
proas75028802proas
prods85523552prods
profs105120892profs
prog75729002prog_
proms95426412proms
prongs94314482prongs
props95726882props
pros65742782pro_s
pross76529402pross
prows106327012prows
rags55448372_rags
regs55436572_regs
rigs55137592_rigs
robs65837872_robs
rocs65533662_rocs
rods56442062_rods
roes45954142_roes
roms67038962_roms
rots46454092_rots
rows75941752_rows
rugs56033682_rugs
shogs95319712shogs
slogs64521842slogs
smogs85112162smogs
snogs66017492snogs
togs57242432_togs
trigs65423062trigs
trog57628212trog_
trois57226092trois
trots56629942trots
trows88826182trows
troys86418612troys
trugs65516802trugs
vrows116115262vrows
wogs86531402_wogs
wrongs10338932wrongs

Search took 3 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 Filter178691538000.360496363.9
2DLD Change Limit538001651.73331044.4
3Display Results1651650.0503300.0
 (SQL Overall)1786911652.14383383.6
 
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.