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

143 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
groves10431810(None) 
droves105116671droves
gloves104115181gloves
graves104624001graves
grooves11368801grooves
gropes95220401gropes
grove95219331grove_
groved114413701groved
grovel104310541grovel
grovels11427811grovels
proves114322251proves
roves84834481_roves
troves94719111troves
aboves114512842aboves
braves115524082braves
breves115516422breves
bromes104719762bromes
broses86524402broses
cloves114918822cloves
corves115122522corves
coves105539172_coves
craves115825392craves
crones84729242crones
crores86121162crores
crozes174417662crozes
doves94728152_doves
drives105117112drives
drones75023432drones
drove95518062drove_
droved114611642droved
drover104614592drover
drovers115212642drovers
erodes74819882erodes
eroses65327052eroses
froes86126692fro_es
garotes8614562garotes
geodes8412152geodes
gives95324872g_ives
globes94314542globes
glove94516292glove_
gloved114811872gloved
glover104513532glover
glovers114310882glovers
glozes164313352glozes
gnomes93812972gnomes
gnoses76515162gnoses
goes55644092g_o_es
gooses75723052gooses
gores65740372g_ores
gorges85321892gorges
gorses74723292gorses
goxes135018262g_oxes
graces94523492graces
grades84926312grades
grapes95123122grapes
grates75429882grates
grave94624872grave_
graved114818812graved
gravel105313822gravel
gravels113611142gravels
graven104513522graven
graver105018592graver
gravers114515262gravers
gravest114011632gravest
gravies11314092gravies
grazes164519642grazes
greaves113311442greaves
grebes93813612grebes
grees65132472gr_ees
grides84422362grides
grieves1137322grieves
grimes94619032grimes
gripes94619872gripes
grivet103517822grivet
grivets11357972grivets
groans74815062groans
groats74816652groats
grocer94212142grocer
grocers103511252grocers
grogs76319412gro_gs
groins73917202groins
groks105716122gro_ks
grooms94512522grooms
groove10438872groove_
grooved12347252grooved
groover11358542groover
groovers12337122groovers
grope84821612grope_
groped107515052groped
groper94517252groper
gropers104813852gropers
gross65421692gro_ss
grosses84517682grosses
grots65025852gro_ts
groups94210512groups
grouse74315022grouse
grouses84616542grouses
grouts75015612grouts
grower104614932grower
growers113612722growers
growls104711112growls
grows95523922gro_ws
groynes1137822groynes
grues65721962gr_ues
grumes94415552grumes
gyves125711552g_yves
hooves124815482hooves
irones64724012irones
loves85332012_loves
moves106128422_moves
pooves113914712pooves
probes104119452probes
proles84627202proles
proses84733472proses
prove104823192prove_
proved125016032proved
proven114314772proven
prover113819722prover
provers123817792provers
raves85441972_raves
rives85336002_rives
robes75133302_robes
rodes614039082_rodes
roes45954132_ro_es
roles56747982_roles
ropes75940062_ropes
roses56445772_roses
rotes56143902_rotes
roues56039352_roues
rove75136982_rove_
roved95323552_roved
roven85521972_roven
rover85527372_rover
rovers95423522_rovers
shoves124919412shoves
stoves93818922stoves
traves94222742traves
trokes104019262trokes
trones65629282trones
tropes84824352tropes
trove85221922trove_
trover95014662trover
trovers103713312trovers

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 Filter178691825510.1101624463.6
2DLD Change Limit825511432.47033421.5
3Display Results1431430.0304766.7
 (SQL Overall)1786911432.61068464.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.