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

164 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
prove10482319(None) 
drove95518061drove
grove95219331grove
poove104514301poove
probe94320811probe
prole74527791prole
prone75332621prone
prose75835121prose
proved125016031proved
proven114314771proven
prover113819721prover
proves114322251proves
rove75136981_rove
trove85221921trove
above105414322above
approve14116602approve
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
glove94516292glove
grave94624872grave
groove10438872groove
grope84821612grope
groved114413702groved
grovel104310542grovel
groves104318102groves
hove107132222_hove
improve1435962improve
irone55126362irone
krone94018732krone
love75234762_love
move96630722_move
pareve114613012pareve
parole84425252parole
parve109824852parve
pave96133892p_ave
peeve104915252peeve
phone105621932phone
plover115312612plover
poke105335362p_oke
pole65951302p_ole
pome85636692p_ome
pone65747532p_one
pooves113914712pooves
pope85535612p_ope
pore66451262p_ore
porose84818742porose
pose66441732p_ose
prase76128752prase
prate75135982prate
pree67044732pr_ee
prese75228382prese
prevue1179162prevue
price93725412price
pride84724732pride
prime96525602prime
prise74632612prise
privet113821342privet
privy13439832privy
prize164718942prize
pro55837262pro__
proa66229962pro_a
proas75028802proas
probed114114822probed
prober104516072prober
probes104119452probes
prod76129502pro_d
prods85523552prods
proem94818272proem
prof96134662pro_f
profs105120892profs
prog75729002pro_g
progs86624152progs
projet15315182projet
proleg94612112proleg
proles84627202proles
prom87631702pro_m
promo95620002promo
proms95426412proms
prong85218112prong
proof105221532proof
prop85932812pro_p
propel103714062propel
proper104319952proper
props95726882props
pros65742782pro_s
prosed94921092prosed
proser84223462proser
proses84733472proses
proso77222412proso
pross76529402pross
prost75434102prost
prosy106319252prosy
protea82214762protea
protei82615312protei
proud84615482proud
proverb14378212proverb
provers123817792provers
provide1339852provide
provoke1676122provoke
prow97030382pro_w
prower114218122prower
prowl105615122prowl
prows106327012prows
proxy175011012proxy
prude84615972prude
prune75119632prune
psoae74411622psoae
pyrone112714472pyrone
pyrope132810532pyrope
rave75542092_rave
reprove122911072reprove
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
updove1234482updove
uphove1436132uphove
uprose82311482uprose
wove105624312_wove
wrote84717482wrote

Search took 2 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.296603685.8
2DLD Change Limit538001641.62633087.3
3Display Results1641640.0463565.2
 (SQL Overall)1786911641.96890798.3
 
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.