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 “proteas” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

507 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
proteas9201512(None) 
protea82214761protea_
protean92412191protean
proteans102811541proteans
protease10209891protease
proteus92511591proteus
porters93722702porters
praters94921652praters
prates84633162prate_s
proas75028802pro__as
probers113514582probers
probes104119452probe_s
process11310402process
proems104711162pro_ems
profess1237712profess
projets1639162projets
prolegs10379992prolegs
proles84627202prole_s
propels113412842propels
propers113619032propers
prosers94219642prosers
proses84733472prose_s
proteases112110832proteases
protect11313632protect
protects1239742protects
protege1059152protege
proteges1149922proteges
protei82615312prote_i
proteid103513672proteid
proteids11259942proteids
protein92414732protein
proteins102114282proteins
protend104012792protend
protends113010352protends
proteose10229412proteose
protest9317532protest
protests10310492protests
protons93118002protons
protyls12298462protyls
provers123817792provers
proves114322252prove_s
prowess1237902prowess
rotas54827722_rot_as
rotes56143902_rote_s
aortas65417783aort_as
apnoeas946353apno_eas
areas55935773ar__eas
aretes64425353arete_s
aromas81018613aro_mas
artels66216233ar_tels
azotes154312223azote_s
biotas84313923biot_as
boheas114013213_boheas
bootees94114473bootees
boreas85421733_boreas
botas75328783_bot_as
botels84815803_botels
brokers133111913brokers
bromes104719763brome_s
broses86524403brose_s
brothels13277073brothels
brothers133410833brothers
broths115013923brot_hs
brutes86118683brute_s
choreas124414203choreas
cooters94525723cooters
corneas94717003corneas
coteau8311083_coteau
cotes76347843_cote_s
cottas84615573_cottas
craters95021893craters
crates85736063crate_s
crofters13358903crofters
crones84729243crone_s
crores86121163crore_s
crotons93714373crotons
croutes94815653croute_s
crowers124614903crowers
crozers184111083crozers
crozes174417663croze_s
doters74423913_doters
dotes65836693_dote_s
droners84114383droners
drones75023433drone_s
droseras935873droseras
drovers115212643drovers
droves105116673drove_s
elodeas836963elodeas
emoters94712873emoters
emotes84620283emote_s
erodes74819883erode_s
eroses65327053erose_s
erotics91914153erotics
flotas94013003flot_as
footers104618333footers
fortes95327183forte_s
foveas1238623_foveas
fraters103517213fraters
frites94922483frite_s
froes86126693fro_e_s
frontes104214163fronte_s
frosteds12305653frosteds
frothers14279813frothers
froths125411443frot_hs
garotes8614563garote_s
graters85419743graters
grates75429893grate_s
grocers103511253grocers
gropers104813853gropers
gropes95220403grope_s
grots65025853grot__s
grottos8337333grottos
grouters95910083grouters
grovels11427813grovels
groves104318103grove_s
growers113612723growers
hooters104520473hooters
hotels94515513_hotels
iotas54821113_iot_as
ironers74813553ironers
irones64724013irone_s
jotas125717443_jot_as
kraters114212343kraters
looters74419163looters
lotas55926303_lot_as
mooters93818623mooters
motels83616893_motels
motes75944003_mote_s
motets84216193_motets
noters64021003_noters
notes55034583_note_s
orates64328613orate_s
palters94021683palters
parolees104313983parolees
paroles95025883parole_s
parotids112610413parotids
parroters1156763parroters
pastas85422873past_as
pastels95215183pastels
pasters94531733pasters
pastes85233913paste_s
patens84820863p_atens
paters84935833p_aters
pates76047893p_ate_s
pattens95414923pattens
patters94825193patters
peas65755063p___eas
pectens11189203pectens
pelotas9410723pelot_as
pelters93720313pelters
peones83821043peone_s
peroneal1049173peroneal
pesetas938753pesetas
pesters93827093pesters
peters86624593p_eters
petters93722363petters
pewters124113353pewters
peyotes1238483peyote_s
phobias14228183phobias
phones114121213phone_s
phoneys15437143phoneys
photics142810483photics
photogs13358213photogs
photons123814433photons
photos113316643phot_os
phots105418503phot__s
picotees1247113picotees
pietas84516503piet_as
pintas85021393pint_as
piolets93513193piolets
pirates93020333pirate_s
pistes85325633piste_s
pitas77427673p_it_as
pittas86014523p_ittas
plateau937403plateau
plateaus1035533plateaus
platens94213983platens
platers93924093platers
plates85432243plate_s
pleas75627033p__leas
plotless10256793plotless
plots75025673plot__s
plotters104011553plotters
plotzes18317703plotzes
plovers123611833plovers
plowers123812243plowers
pluteus9326243pluteus
poems95715553p_o_ems
poetess938933poetess
poets76024443p_o_ets
pogeys124110353p_ogeys
pokers124617923p_okers
pokes116133013p_oke_s
pokeys15529513p_okeys
poleax1547993p_oleax
poleis86018353p_oleis
polers84225643p_olers
poles75351003p_ole_s
polkas1239103p_olkas
pomes94833933p_ome_s
pones74547043p_one_s
pontes83627853ponte_s
poofters1336923poofters
poolers94217423poolers
pooves113914713poove_s
popes95933813p_ope_s
poppas93710713p_oppas
pores75849033p_ore_s
porkers134314933porkers
portal84218463port_al
portals94015563portals
ported94223243porte_d
portend103411193portend
portends11358963portends
portent93619643portent
portents103512823portents
porter84224413porte_r
portless10310643portless
portray1237483portray
portrays1345293portrays
portress1038323portress
ports75934593port__s
posers84223973p_osers
poses74642763p_ose_s
posters93928013posters
potash1138273p_ot_ash
poteen83514263p_oteen
poteens92910883p_oteens
potent84223353p_otent
pothead133810393p_othead
potheads14298543p_otheads
pothers123818623p_others
pothos114214693p_othos
potman102813573p_otman
pots66452363p_ot__s
potters94024343potters
pottos84615873p_ottos
potzers184010543p_otzers
pouters94221873pouters
powers113822323p_owers
powters124015663powters
poxes145325723p_oxe_s
prajnas1635453prajnas
prases84429023prase_s
prate75135983prate__
prated94924923prate_d
prater84825353prate_r
prats76333393prat__s
praxes156215183praxe_s
prayers124212853prayers
precess11310863precess
preens85020113pr_eens
prees75937173pr__ees
prefers123713333prefers
preheat12413893preheat
preheats1339413preheats
premeal11310523premeal
premeds12389593premeds
preps96220693pr__eps
presa74319043pr__esa
presets94216423presets
press75425953pr__ess
presters103419003presters
pretax152310193pret_ax
preteen939873preteen
preteens1038123preteens
pretell938243pretell
pretells1047333pretells
pretend104011013pretend
pretends11299113pretends
pretense10199823pretense
preterm11310163preterm
preterms1237223preterms
pretest9517633pretest
pretests10310013pretests
pretext1639663pretext
pretexts1735603pretexts
pretors9316813pretors
pretreat10311923pretreat
pretreats1146933pretreats
pretzels1934033pretzels
prexes154915953prexe_s
preyers124412363preyers
preys105717783pr__eys
prezes173614693preze_s
pricers113915063pricers
prices104524543price_s
prides94324183pride_s
priers84521193pr_iers
pries74339533pr_ie_s
primas104418103pr_imas
primers114215673primers
primes104225263prime_s
printers103214903printers
prioress1035393prioress
prises84133173prise_s
privets122910053privets
prizers183911843prizers
prizes173819813prize_s
proa66229963pro__a_
probates12414283probate_s
probe94320813probe__
probed114114823probe_d
prober104516073probe_r
probits112712573probits
problems1434343problems
proceed12310553proceed
proceeds1335983proceeds
proctors12311513proctors
prodders1237463prodders
prods85523553pro__ds
proem94818273pro_e_m
proette9312363proette
proettes10312763proettes
proffers16126593proffers
profiters14228313profiters
profits122911243profits
profs105120893pro__fs
progeny1389463progeny
progerias1248623progerias
proggers12258163proggers
program12311693program
programs1339783programs
progress1137023progress
progs86624153pro__gs
project1838453project
projects1936413projects
projet15315183proje_t
prolan8414693pro_lan
prolans9314273prolans
prole74527793prole__
proleg94612113prole_g
prologs103512133prologs
promos105116423pro_mos
promoters13310093promoters
promotes12314123promote_s
prompters1537553prompters
prompts1337473prompts
proms95426413pro__ms
pronates10418373pronate_s
prone75332623prone__
pronely12310253pronely
prongs94314483pro_ngs
proofers13118363proofers
proofs114511683pro_ofs
propel103714063prope_l
propend123311273propend
propends13249173propends
propene112716043propene
propenes122816513propenes
propense122410103propense
proper104319953prope_r
prophase15410243prophase
prophets1539503prophets
propjets1935493propjets
propman1339063propman
props95726883pro__ps
propyls14308193propyls
prorates10418073prorate_s
pros65742783pro___s
prose75835123prose__
prosect11313393prosect
prosects1239473prosects
prosed94921093prose_d
proser84223463prose_r
prosomas1249723prosomas
prosos85718553pro_sos
prospers123012263prospers
pross76529403pro__ss
prosses94019513prosses
prosties101421193prosties
protases102115033protases
protasis102411973protasis
protegee1156963protegee
protegees1275393protegees
proteide11239723proteide
proteides12238783proteides
proteinase1244533proteinase
proteome12228423proteome
proteomes13248653proteomes
proteoses112211013proteoses
proteuses11238993proteuses
protheses1449073protheses
prothesis1449433prothesis
protist9320223protist
protists10313363protists
protium11312293protium
protiums1238553protiums
proton84318893prot_on
protract12510603protract
protracts1347023protracts
protrade1148213protrade
protyl11308213prot_yl
protyle12229453protyle
protyles13249833protyles
prove104823193prove__
proved125016033prove_d
proven114314773prove_n
prover113819723prove_r
proverb14378213proverb
proverbs15315583proverbs
prowar114110943pro_war
prower114218123prowe_r
prowest12311533prowest
prowlers13328933prowlers
prowls115511083pro_wls
prows106327013pro__ws
proxies163014933proxies
prudes94215443prude_s
pruners93710723pruners
prunes83419063prune_s
pruta7314243prut_a_
prutah1136583prut_ah
pryers115012243pr_yers
psoas75012983pso__as
ptoses83514673ptose_s
punters93617043punters
puttees93612913puttees
putters94219193putters
pyoses114314303pyose_s
pyrites12812203pyrite_s
pyrogens1437293pyrogens
pyrolas1239863pyro_las
pyrones123113303pyrone_s
pyropes142210193pyrope_s
quotas15339433quot_as
quoters16369263quoters
quotes153312463quote_s
ratels64518213_ratels
raters63936583_raters
rates55352013_rate_s
reteam83214533_reteam
reteams9339563_reteams
retear63115483_retear
retears72814923_retears
retems83914573_retems
rheas84816953_r_heas
rioters73615513rioters
rites54442553_rite_s
robes75133303_robe_s
rodeos75314503_rodeos
rodes614039083_rode_s
roes45954143_ro_e_s
rogers74517913_rogers
roles56747983_role_s
romeos84013173_romeos
rooters74522933rooters
ropers84325903_ropers
ropes75940063_rope_s
roses56445773_rose_s
rosets65819953_rosets
rosters73727543_rosters
rota45834343_rot_a_
rote46249023_rote__
rotis56327063_rot_is
rotls55620163_rot_ls
rotors64917953_rotors
rotos56027883_rot_os
rots46454093_rot__s
rotters74421393_rotters
rottes64524833_rottes
rouens64814443_rouens
roues56039353_roue_s
routers74822873_routers
routes66129313_route_s
rovers95423523_rovers
roves84834483_rove_s
rowels94515453_rowels
rowens94515303_rowens
rowers94924573_rowers
scoters93313813scoters
scotias939753scotias
shotes95321913shote_s
sorters74221133sorters
sporters103714063sporters
sprites94220333sprite_s
teas45851493___teas
toeas55726423_to_eas
tooters73818773tooters
tortas64918253tort_as
tortes64826053torte_s
totems86810763_totems
toters65026363_toters
totes55139683_tote_s
troikas1135033troikas
trokes104019263troke_s
tronas63816903tro_nas
trones65629283trone_s
tropes84824353trope_s
troths95414153trot_hs
trots56629943trot__s
trotters83310243trotters
trotyls10236033trotyls
trovers103713323trovers
troves94719113trove_s
trowels10358363trowels
uprates93814863uprate_s
uprooters1164253uprooters
urates65027763urate_s
ureas55826013ur__eas
ureters7311823ureters
voters95017443_voters
votes84627083_vote_s
writers105513493writers
writes94420333write_s
wrote84717483wrote__
zoeas145815613_zo_eas

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 Filter1786911340270.406440125.6
2DLD Change Limit1340275076.37621020.5
3Display Results5075070.1862725.8
 (SQL Overall)1786915076.96825644.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.