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

150 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
grove9521933(None) 
drove95518061drove
glove94516291glove
grave94624871grave
groove10438871groove
grope84821611grope
groved114413701groved
grovel104310541grovel
groves104318101groves
prove104823191prove
rove75136981_rove
trove85221921trove
above105414322above
arose55832082arose
brave104925502brave
breve105317052breve
broke116019782broke
brome94421972brome
brose75227032brose
clove105619442clove
cove95837072_cove
crave105626312crave
crone75231332crone
crore74922872crore
croze164719452croze
dove85131562_dove
drave95219272drave
drive95318002drive
drone65324982drone
droved114611642droved
drover104614592drover
droves105116672droves
erode64520992erode
erose55727272erose
froe75329992fro_e
frore86218802frore
froze174515652froze
garote7717952garote
gave84634052g_ave
geode7412592geode
give85829352g_ive
globe84917012globe
gloved114811872gloved
glover104513532glover
gloves104115182gloves
gloze154815982gloze
gnome84213952gnome
gone55639042g_one
goose65925902goose
gore55744962g_ore
gorge76423892gorge
gorse65926812gorse
grace85124542grace
grade75126092grade
grape84824662grape
grate64932882grate
graved114818812graved
gravel105313822gravel
graven104513522graven
graver105018592graver
graves104624002graves
gravy125512112gravy
graze155820052graze
greave104611492greave
grebe85114942grebe
gree56641562gr_ee
gride75223582gride
grieve1047242grieve
grime85021322grime
gripe84622962gripe
grivet103517822grivet
groan65618422groan
groat65531972groat
grocer94212142grocer
grody103412062grody
grog65923342gro_g
grogs76319412grogs
groin65521082groin
grok95819682gro_k
groks105716122groks
groom85317982groom
grooved12347252grooved
groover11358542groover
grooves11368802grooves
groovy13375402groovy
groped107515052groped
groper94517252groper
gropes95220402gropes
gross65421692gross
grosz154814092grosz
grosze16457732grosze
grot55942052gro_t
grots65025852grots
group85413922group
grouse74315022grouse
grout65330422grout
grovels11427812grovels
grow86127302gro_w
grower104614932grower
growl96115822growl
grown95317352grown
grows95523922grows
groyne1037212groyne
grue55825712gr_ue
grume86218162grume
gyrose105310252gyrose
gyve116215082g_yve
hove107132222_hove
irone55126362irone
krone94018732krone
love75234762_love
move96630722_move
poove104514302poove
probe94320812probe
prole74527792prole
prone75332622prone
prose75835122prose
proved125016032proved
proven114314772proven
prover113819722prover
proves114322252proves
rave75542092_rave
rive75537722_rive
robe65335642_robe
rode55844302_rode
roe36861082_ro_e
role45851822_role
rope65542912_rope
rose46148902_rose
rote46249022_rote
roue45941742_roue
roved95323552_roved
roven85521972_roven
rover85527372_rover
roves84834482_roves
shove114421042shove
shrove125412232shrove
stove85220252stove
strove95014792strove
throve128012392throve
trave85223032trave
trode65322852trode
troke94821052troke
trone55131862trone
trope75725802trope
trover95014662trover
troves94719112troves
unrove92511682unrove
wove105624312_wove
wrote84717482wrote

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.343520965.0
2DLD Change Limit538001501.76630464.3
3Display Results1501500.0334545.5
 (SQL Overall)1786911502.14283422.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.