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

230 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
prose7583512(None) 
arose55832081arose
brose75227031brose
erose55727281erose
porose84818741porose
pose66441731p_ose
prase76128751prase
prese75228381prese
prise74632611prise
probe94320811probe
prole74527791prole
prone75332621prone
pros65742781pros_
prosed94921101prosed
proser84223461proser
proses84733471proses
proso77222411proso
pross76529401pross
prost75434101prost
prosy106319251prosy
prove104823191prove
rose46148901_rose
uprose82311481uprose
appose10411992appose
ariose64818732ariose
arise56436432arise
arkose104911342arkose
arouse65019982arouse
arse46539272ar_se
broke116019782broke
brome94421972brome
bros65635662bros_
broses86524402broses
brosy106115382brosy
browse115713862browse
chose105925402chose
close76425222close
corse75036182corse
crone75231332crone
crore74922872crore
cross75124502cross
crosse85216312crosse
crouse84619372crouse
croze164719452croze
cruse75726102cruse
dose56442432_dose
drone65324982drone
dross65418092dross
drove95518062drove
drowse105010552drowse
druse64817662druse
erase54925492erase
erode64520992erode
eros45238452eros_
eroses65327062eroses
frise85322452frise
froe75329992fro_e
froes86126692froes
frore86218802frore
frosh115713402frosh
frost84727832frost
froze174515652froze
goose65925902goose
gorse65926812gorse
grope84821612grope
gross65421692gross
grosz154814092grosz
grosze16457732grosze
grouse74315022grouse
grove95219332grove
gyrose105310252gyrose
horse86132652horse
hose76547242_hose
irone55126362irone
krone94018732krone
leprose938552leprose
loose56627682loose
lose45144582_lose
moose76327192moose
morose85116242morose
morse76032702morse
noose55624062noose
nose46739362_nose
operose939432operose
oppose1039192oppose
ose38147342__ose
paise75028332paise
parole84425252parole
parse75236992parse
pase65346862p_ase
passe75525692passe
pause75021832pause
pease75231112pease
peise75825772peise
perse75429522perse
peruse84016842peruse
phase104617212phase
phone105621932phone
phrase11109902phrase
pilose84514242pilose
poise75127892poise
poke105335362p_oke
pole65951302p_ole
pome85636692p_ome
pone65747532p_one
poos65949112poos_
poove104514302poove
pope85535612p_ope
pore66451262p_ore
pores75849032pores
posed85828412p_osed
poser75128772p_oser
poses74642762p_oses
posh95427322p_osh
posse74722272posse
post67953362p_ost
posy96028422p_osy
praise84419412praise
praos74923562praos_
prases84429022prases
prate75135982prate
pree67044732pr_ee
prees75937172prees
presa74319042presa
preset84430982preset
press75425952press
prest75736352prest
price93725412price
pride84724742pride
pries74339532pries
prime96525602prime
prised94322202prised
prises84133172prises
prism94820262prism
priss74623892priss
prize164718942prize
pro55837262pro__
proa66229962pro_a
proas75028802proas
probed114114822probed
prober104516072prober
probes104119452probes
prod76129502pro_d
prods85523552prods
proem94818272proem
prof96134662pro_f
profs105120892profs
profuse1237152profuse
prog75729002pro_g
progs86624152progs
projet15315182projet
proleg94612112proleg
proles84627202proles
prom87631702pro_m
promise113415842promise
promo95620002promo
proms95426412proms
prong85218112prong
proof105221532proof
prop85932812pro_p
propel103714062propel
proper104319952proper
propose112714842propose
props95726882props
prosect11313392prosect
prosers94219642prosers
prosier93817492prosier
prosit85124592prosit
prosos85718552prosos
prosper114012192prosper
prosses94019512prosses
prossie91812962prossie
prostie91617742prostie
protea82214762protea
protei82615312protei
proud84615482proud
proved125016032proved
proven114314772proven
prover113819722prover
proves114322252proves
prow97030382pro_w
prower114218122prower
prowl105615122prowl
prows106327012prows
proxy175011012proxy
prude84615972prude
prune75119632prune
psoae74411622psoae
ptoses83514672ptoses
pulse74219972pulse
purpose1137382purpose
purse76028892purse
pyoses114314302pyoses
pyrone112714472pyrone
pyrope132810532pyrope
pyros105718292pyros_
rase46149982_rase
rerose63320852rerose
rise45945242_rise
robe65335642_robe
rode55844312_rode
roe36861082_ro_e
roes45954142_roes
role45851822_role
roose56127092roose
rope65542912_rope
rosed65930352_rosed
roses56445772_roses
roset55945242_roset
rosy76024872_rosy
rote46249022_rote
roue45941742_roue
rouse56634702_rouse
rove75136982_rove
ruse45938932_ruse
those85218142those
torose64317692torose
torse55833332torse
triose64715382triose
trode65322852trode
troke94821052troke
trone55131862trone
trope75725802trope
trove85221922trove
uprise82313692uprise
uprouse937222uprouse
urase54624692urase
whose114914532whose
worse86525262worse
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.313570897.8
2DLD Change Limit538002301.76630464.3
3Display Results2302300.0633650.8
 (SQL Overall)1786912302.14283422.5
 
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.