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

157 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
groks10571612(None) 
gooks105422881gooks
grogs76319411grogs
grok95819681grok_
gross65421691gross
grots65025851grots
grows95523921grows
amoks11413552amoks
araks94820882araks
arks85936872ar_ks
books115729712books
borks115727702borks
brocks145214152brocks
broke116019782broke
brooks125813882brooks
broos75126412broos
bros65635662bro_s
brows105425982brows
cooks115429142cooks
corks116028272corks
croaks125812982croaks
crocks145118422crocks
crocs95722432crocs
crooks124914412crooks
crops96125232crops
cross75124502cross
crows105727312crows
dorks105724442dorks
dreks105714752dreks
drops85719502drops
dross65418092dross
drouks1137122drouks
eros45238452ero_s
forks125324682forks
frocks154111212frocks
froes86126692froes
frogs96220772frogs
frons86124042frons
frows116623102frows
gaols66717572gaols
gawks136811632gawks
gecks125117092gecks
geeks104915842geeks
ginks104319562ginks
girons75014372girons
giros65722652giro_s
globs85616402globs
gloms85219782gloms
glops85619552glops
gloss64319622gloss
glows95518032glows
goas55239942g_oas
gobs76935572g_obs
gods65438042g_ods
goes55644092g_oes
goods75124482goods
goofs94821002goofs
gook96429602gook_
gooky135818032gooky
goons65326772goons
goops86620962goops
goos57644912g_oos
gores65740372gores
gorms85619592gorms
gorps85316992gorps
gos47155132g_o_s
gowks136011952gowks
goys86328412g_oys
grabs85719692grabs
grads75625752grads
grams85327312grams
grans64832542grans
grass66125202grass
grays95621332grays
grees65132472grees
greys96614852greys
grids75321392grids
grigs75318192grigs
grins65427222grins
griots74713642griots
grips85520132grips
grits65529582grits
groan65618422groan
groans74815062groans
groat65531972groat
groats74816652groats
grody103412062grody
grog65923342gro_g
groin65521082groin
groins73917202groins
groom85317982groom
grooms94512522grooms
grope84821612grope
gropes95220402gropes
grosz154814092grosz
grot55942052gro_t
group85413922group
groups94210512groups
grouse74315022grouse
grout65330422grout
grouts75015612grouts
grove95219332grove
groves104318102groves
grow86127302gro_w
growl96115822growl
growls104711112growls
grown95317352grown
grubs86312602grubs
grues65721962grues
gucks123917302gucks
gunks104517722gunks
gyrons105511222gyrons
gyros95616482gyro_s
hooks125027122hooks
irks86220132ir_ks
iroko939662iroko
irokos1037232irokos
irons55324132irons
kooks85217262kooks
looks95124862looks
nooks95420392nooks
porks115124142porks
proas75028802proas
prods85523552prods
profs105120892profs
progs86624152progs
proms95426412proms
props95726882props
pros65742782pro_s
pross76529402pross
prows106327012prows
robs65837872_robs
rocks114626412_rocks
rocs65533662_rocs
rods56442062_rods
roes45954142_roes
roms67038962_roms
rooks95325042rooks
rots46454092_rots
rows75941752_rows
sooks94425452sooks
taroks106115282taroks
treks96016852treks
troaks104410602troaks
trocks123614632trocks
trogs67022602trogs
trois57226092trois
troke94821052troke
trokes104019262trokes
trots56629942trots
trows88826182trows
troys86418612troys
vrows116115262vrows
woks116224902_woks
works125621902works
yoks116223742_yoks
zooks184716942zooks

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 Limit538001571.62633087.3
3Display Results1571570.0463413.0
 (SQL Overall)1786911572.03287938.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.