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

225 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
prone7533262(None) 
crone75231331crone
drone65324981drone
irone55126361irone
krone94018731krone
phone105621931phone
pone65747531p_one
probe94320811probe
prole74527791prole
prong85218111prong
prose75835121prose
prove104823191prove
prune75119631prune
pyrone112714471pyrone
trone55131861trone
agone65924552agone
alone55732962alone
apron7318832apron_
aproned10311502aproned
aprons8316992aprons
arene55329412arene
arose55832082arose
atone56527982atone
axone125918472axone
bone65949322_bone
borne77926792borne
brine75132272brine
broke116019782broke
brome94421972brome
bronc91714342bronc
bronze173610922bronze
brose75227032brose
clone75728162clone
cone67256962_cone
crane75331602crane
crones84729242crones
crony105918672crony
crore74922872crore
croze164719452croze
done55747912_done
droned84616862droned
droner74717672droner
drones75023432drones
drove95518062drove
erne46727432er_ne
erode64520992erode
erose55727282erose
froe75329992fro_e
frond95316342frond
frons86124042frons
front85029222front
frore86218802frore
froze174515652froze
gone55639042_gone
grope84821612grope
grove95219332grove
groyne1037212groyne
hone77549322_hone
iron46728462iron_
ironed74916012ironed
ironer64216452ironer
irones64724012irones
irons55324132irons
irony85015902irony
krona93611792krona
kronen10348912kronen
kroner104612572kroner
leone55018822leone
lone45849132_lone
none45743172_none
one37050912__one
orgone71110912orgone
ozone14310612ozone
padrone102512072padrone
pane64950292p_ane
panne76623652panne
parole84425252parole
penne75423852penne
peon65635242peon_
peones83821042peones
peons75327182peons
peony105717562peony
phon95925382phon_
phoned124014552phoned
phones114121212phones
phoney143612982phoney
phono104917022phono
phons105221142phons
phony136715442phony
pine67755722p_ine
pion67235302pion_
pions75826392pions
plane74929142plane
plonk114613982plonk
poke105335362p_oke
pole65951302p_ole
pome85636692p_ome
ponce95222512p_once
pond75530492p_ond
pones74547042p_ones
pong76231142p_ong
pons65850602p_ons
pony96434052p_ony
poon67341262poon_
poons75430972poons
poove104514302poove
pope85535612p_ope
pore66451262p_ore
porn65636022porn_
porno75120652porno
porns75527342porns
porny106020192porny
porose84818742porose
pose66441732p_ose
prance104318572prance
prang84820322prang
prank115019452prank
prase76128752prase
prate75135982prate
pree67044732pr_ee
preen75925052preen
prese75228382prese
price93725412price
pride84724742pride
prime96525602prime
prince104114762prince
prink114719672prink
print74837462print
prion75119992prion_
prions84317782prions
prise74632612prise
prize164718942prize
pro55837262pro__
proa66229962pro_a
proas75028802proas
probed114114822probed
prober104516072prober
probes104119452probes
prod76129502pro_d
prods85523552prods
proem94818272proem
prof96134662pro_f
profane122111862profane
profs105120892profs
prog75729002pro_g
progs86624152progs
projet15315182projet
proleg94612112proleg
proles84627202proles
proline92321592proline
prom87631702pro_m
promine112819442promine
promo95620002promo
proms95426412proms
pronate9418872pronate
pronely12310252pronely
pronged113912392pronged
prongs94314482prongs
pronto8313992pronto
proof105221532proof
prop85932812pro_p
propane112716152propane
propel103714062propel
propene112716042propene
proper104319952proper
propine113020212propine
propone112716302propone
props95726882props
pros65742782pro_s
prosed94921102prosed
proser84223462proser
proses84733472proses
proso77222412proso
pross76529402pross
prost75434102prost
prosy106319252prosy
protea82214762protea
protei82615312protei
proud84615482proud
proved125016032proved
proven114314772proven
prover113819722prover
proves114322252proves
prow97030382pro_w
prower114218122prower
prowl105615122prowl
prows106327012prows
proxy175011012proxy
prude84615972prude
pruned93413112pruned
pruner83413462pruner
prunes83419062prunes
psoae74411622psoae
purine85321892purine
pyrene113210732pyrene
pyrones123113302pyrones
pyrope132810532pyrope
robe65335642_robe
rode55844312_rode
roe36861082_ro_e
role45851822_role
rope65542912_rope
rose46148902_rose
rote46249022_rote
roue45941742_roue
rove75136982_rove
rune45236302_rune
scone74621832scone
shone83725982shone
sone46649982_sone
stone55431182stone
throne98517602throne
tone46953742_tone
trine54734602trine
trode65322852trode
troke94821052troke
trona54118952trona
trones65629282trones
trope75725802trope
trove85221922trove
uprose82311482uprose
urine55026602urine
wrong94712322wrong
wrote84717482wrote
zone135231082_zone

Search took 7 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.673265514.1
2DLD Change Limit538002255.9069109.4
3Display Results2252250.1102045.5
 (SQL Overall)1786912256.68926714.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.