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

251 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
proette931236(None) 
proettes10312761proettes
ariette7312372ariette
palette93613982palette
parkette14138022parkette
pipette1137942pipette
pirouette1144452pirouette
pretty11510872pr_etty
probate11414482probate
prolate9419792prolate
promote11313142promote
pronate9418872pronate
prorate9418732prorate
prostate10314532prostate
prostie91617742prostie
protege1059152protege
rosette7310372_rosette
rotte54625932_ro_tte
arete56031353ar_e_te
arietta788903arietta
ariettes8411353ariettes
barbette1249113barbette
barrette1039783barrette
briolette1144183briolette
brochette1645223brochette
bromate11313553bromate
brunette1044723brunette
burette939853burette
casette9310393casette
corvette1338093corvette
create85126373cr_eate
croquette2043653croquette
croute84617273cro_ute
curette939783curette
cuvette1235833cuvette
dinette8310013dinette
fouette1038213fouette
fretted113411853fr_etted
fretter103412753fr_etter
fretty1249223fr_etty
frisette1195483frisette
frizette2093503frizette
fumette1245523fumette
galette84212693galette
garotte868703garo_tte
gazette17357363gazette
genette838863genette
grisette994653grisette
grotto7349813gro_tto
grotty10389833gro_tty
layette1037133layette
lotte54923853_lo_tte
lunette737483lunette
mofette1296773mofette
motte75526973_mo_tte
mozette1886773mozette
musette938433musette
navette1036983navette
octette946423octette
paleate94120003paleate
palettes103112833palettes
pallette1039513pallette
palmette1247733palmette
pargetted1345663pargetted
parkettes15137593parkettes
permeate12311603permeate
perorate10417913perorate
petite84320653p__etite
petted94121523p__etted
petter83924773p__etter
petti75119453p__etti
pettle84116053p__ettle
petto76021043p__etto
petty105320293p__etty
phoebe1335003phoe_be
phonate12411813phonate
phorate12413363phorate
pileate93815923pileate
pipetted1335263pipetted
pipettes1237563pipettes
pirouetted1342943pirouetted
pirouettes1254363pirouettes
plotted104612373plo_tted
plotter94113663plo_tter
plotty11208853plo_tty
podite93315353p_odite
poet65552903p_oe_t_
poetic10416843p_oetic
poetise9314043p_oetise
poetize18310773p_oetize
poetry1139383p_oetry
poets76024443p_oe_ts
pointe84619313p_ointe
polite83625073p_olite
postie84123963p_ostie
potted94624013p_o_tted
potter83926983p_o_tter
pottle84416103p_ottle
potto75320943p_o_tto
potty105621003p_o_tty
praetor938973praetor
prate75135983pr__ate
prattle9208833prattle
predate10616893predate
pree67044733pr_e__e
preemie11310563preemie
prelate9519693prelate
premie103617993pr_emie
prese75228383pr_e_se
preset84430983pr_eset
presettle1145933presettle
prest75736353pr_est_
prester93519623pr_ester
presto84216203pr_esto
prests84021263pr_ests
pretape113511623pr_etape
pretaste10139523pr_etaste
pretax152310193pr_etax
preteen939873pr_eteen
pretor8315743pr_etor
prettied1159253pr_ettied
prettier1069043pr_ettier
pretties10615133pr_etties
pretype14387483pr_etype
pretzel1835143pr_etzel
prevue1179163pr_evue
priest84125423priest_
priested1138393priested
priests93810863priests
primate111516283primate
priorate10411733priorate
private121513263private
probated13410863probated
probates12414263probates
probe94320813pro__be
probit103218353probit_
probits112712573probits
probity14299683probity
procreate1348133procreate
proctor11310433proctor
procure1138573procure
produce1267513produce
proem94818273proe__m
proems104711163proe_ms
profane122111863profane
profile123211153profile
profit113016273profit_
profited14279973profited
profiter132710203profiter
profits122911243profits
profuse1237153profuse
project1838453project_
projected21165823projected
projects1936413projects
projet15315183projet_
projets1639163projets
prole74527793pro__le
proline92321593proline
promine112819443promine
promise113415843promise
promoted13310543promoted
promoter12311453promoter
promotes12314123promotes
prompt12313013prompt_
prompted1536903prompted
prompter1437983prompter
prompts1337473prompts
pronated11414053pronated
pronates10418373pronates
prone75332623pro__ne
pronota939763pronota
pronto8313993pro_nto
propane112716153propane
propene112716043propene
propense122410103propense
property1547073property
prophet14316033prophet
propine113020213propine
propjet1839913propjet
propone112716303propone
propose112714843propose
prorated11513713prorated
prorates10418063prorates
prose75835123pro__se
prosect11313393prosect_
prosected14158633prosected
prosects1239473prosects
prosecute1345953prosecute
proselyte1444843proselyte
prosit85124593prosit_
prossie91812953prossie
prost75434103pro_st_
prostates11314423prostates
prosties101421193prosties
prostrate11412483prostrate
prostyle13187273prostyle
protea82214763pro_tea
protean92412193protean
proteas92015123proteas
protease10209893protease
protect11313633protect
protected14158653protected
protecter13179103protecter
protects1239743protects
protegee1156953protegee
proteges1149923proteges
protei82615303pro_tei
proteid103513663proteid
proteide11239723proteide
protein92414723protein
protend104012793protend
proteome12228423proteome
proteose10229413proteose
protest9317533protest
protested12159113protested
protester111510483protester
protests10310483protests
proteus92511593proteus
proton84318893pro_ton
protyl11308213pro_tyl
protyle12229453protyle
proustite1147113proustite
prove104823193pro__ve
provide1339853provide
provoke1676123provoke
prowest12311533prowest_
rente54733783_r_ente
rete44944133_r_e_te
retie55735303_r_etie
retted74826313_r_etted
roomette1046103roomette
rootle63214453_rootle
roquette1755533_roquette
roseate7613453_roseate
rosettes8310343_rosettes
rotate63320343_rotate
rote46249023_ro__te
rotted74524433_ro_tted
rotten64115433_ro_tten
rotter64325463_ro_tter
rottes64524833_ro_ttes
roulette847093_roulette
route55132073_ro_ute
strette7310763strette
syrette1037183syrette
tonette7310373tonette
trotted83711283tro_tted
trotter73312253tro_tter
vedette1166003vedette
vidette1167543vidette
wrote84717483wro__te

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.1561145455.1
2DLD Change Limit1340272516.09321996.9
3Display Results2512510.0763302.6
 (SQL Overall)1786912516.32528251.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.