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

266 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
proettes1031276(None) 
proette9312361proette_
ariettes8411352ariettes
palettes103112832palettes
parkettes15137592parkettes
pipettes1237562pipettes
pirouettes1254362pirouettes
pretties10615132pr_etties
probates12414282probates
promotes12314122promotes
pronates10418372pronates
prorates10418072prorates
prostates11314422prostates
prosties101421192prosties
proteges1149922proteges
rosettes8310342_rosettes
rottes64524832_ro_ttes
aretes64425353ar_e_tes
ariettas847393ariettas
ariette7312373ariette_
barbettes1348163barbettes
barrettes1149063barrettes
briolettes1243853briolettes
brochettes1744703brochettes
bromates12413143bromates
brunettes1144583brunettes
burettes1048953burettes
casettes1039653casettes
corvettes1447433corvettes
creates95225203cr_eates
croquettes2143543croquettes
croutes94815653cro_utes
curettes1039313curettes
cuvettes1335323cuvettes
dinettes9310193dinettes
fouettes1137883fouettes
fretted113411853fr_etted
fretter103412753fr_etter
fretters113410303fr_etters
frisettes1295353frisettes
frizettes2193493frizettes
frontes104214163fro_ntes
fumettes1345773fumettes
galettes93111153galettes
garottes978283garo_ttes
gazettes18296863gazettes
genettes938303genettes
grisettes1094713grisettes
grottoes9276753grottoes
grottos8337333gro_ttos
layettes1136263layettes
lottes65322753_lo_ttes
lunettes836753lunettes
mofettes1386083mofettes
mottes85523693_mo_ttes
musettes1037433musettes
navettes1136613navettes
octettes1045533octettes
palette93613983palette_
pallettes1148803pallettes
palmettes1346883palmettes
pargetted1345663pargetted
parietes10714543parie_tes
parkette14138023parkette_
permeates13311773permeates
perorates11417023perorates
petites93820203p__etites
petted94121523p__etted
petter83924773p__etter
petters93722363p__etters
pettles93916483p__ettles
phoebes1435813phoe_bes
phonates13410643phonates
phorates13413043phorates
pieties9419223p_ieties
pipette1137943pipette_
pipetted1335263pipetted
pirouette1144453pirouette_
pirouetted1342943pirouetted
plotted104612373plo_tted
plotter94113663plo_tter
plotters104011553plo_tters
plotties103111413plotties
plotzes18317703plo_tzes
podites103014733p_odites
poesies93217403p_oesies
poetess938933p_oetess
poetics11312073p_oetics
poetise9314043p_oetise
poetises10313953p_oetises
poetizes19310253p_oetizes
poetless1038723p_oetless
poetries10315583p_oetries
poets76024443p_oe_t_s
pointes93216753p_ointes
pontes83627853p_o_ntes
posties93128813p_osties
posttest10410233p_osttest
potted94624013p_o_tted
potter83926983p_o_tter
potters94024343p_o_tters
potties93723543p_otties
pottles93816983p_ottles
pottos84615873p_o_ttos
praetors1039833praetors
prates84633163pr__ates
prattles10189403prattles
predates11615813predates
preemies12512193preemies
prees75937173pr_e__es
prelates10418573prelates
premies113823063pr_emies
presets94216423pr_esets
presettles1245023presettles
presses93523153pr_esses
prester93519623pr_ester
presters103419003pr_esters
prestos93716083pr_estos
prests84021263pr_est_s
pretapes122811533pr_etapes
pretastes11119423pr_etastes
preteen939873pr_eteen
preteens1038123pr_eteens
pretest9517633pr_e_test
pretors9316813pr_etors
prettied1159253pr_ettied
prettier1069043pr_ettier
prettiest1199803pr_ettiest
pretty11510873pr_ett_y
pretypes15337263pr_etypes
pretzel1835143pr_etzel
pretzels1934033pr_etzels
prevues1239263pr_evues
prexes154915953pr_e_xes
prexies163415003pr_exies
prezes173614693pr_e_zes
priested1138393priested
priestess1145293priestess
priests93810863priest_s
primates121515933primates
priorates11410763priorates
privates131812373privates
probate11414483probate_
probated13410863probated
probes104119453pro__bes
probities13312653probities
probits112712573probit_s
processes13310233processes
procreates1448153procreates
proctitis1348363proctitis
proctors12311513proctors
procures1239213procures
produces1347903produces
proems104711163proe__ms
proestrus1144843proestrus
profanes132311573profanes
professes1437873professes
profiles133211233profiles
profited14279973profited
profiter132710203profiter
profiters14228313profiters
profits122911243profit_s
progenies12314123progenies
projected21165823projected
projects1936413project_s
projets1639163projet_s
prolate9419793prolate_
prolepses13126193prolepses
proles84627203pro__les
prolines102619693prolines
promines123018803promines
promises122916763promises
promote11313143promote_
promoted13310543promoted
promoter12311453promoter
promoters13310093promoters
prompted1536903prompted
prompter1437983prompter
prompters1537553prompters
promptest1546063promptest
prompts1337473prompt_s
pronate9418873pronate_
pronated11414053pronated
propanes122415823propanes
propenes122816513propenes
properties141411883properties
prophets1539503prophets
propines122618933propines
propjets1935493propjets
propones122516963propones
proposes122515973proposes
proptoses1349873proptoses
prorate9418733prorate_
prorated11513713prorated
prosected14158633prosected
prosects1239473prosect_s
prosecutes1445663prosecutes
proselytes1544743proselytes
proses84733473pro__ses
prosses94019513pro_sses
prossies101515223prossies
prostate10314533prostate_
prostie91617743prostie_
prostrates12411993prostrates
prostyles14157113prostyles
protases102115033protases
protea82214763pro__tea
proteans102811543proteans
proteas92015123pro_teas
protease10209893protease
proteases112110833proteases
protected14158653protected
protecter13179103protecter
protecters14168253protecters
protects1239743protects
protege1059153protege_
protegee1156963protegee
protegees1275393protegees
protei82615313pro__tei
proteides12238783proteides
proteids11259943proteids
proteins102114283proteins
protends113010353protends
proteomes13248653proteomes
proteose10229413proteose
proteoses112211013proteoses
protest9317533pro__test
protested12159113protested
protester111510483protester
protesters12169383protesters
protests10310493protests
proteus92511593pro_teus
proteuses11238993proteuses
protons93118003pro_tons
protyles13249833protyles
protyls12298463pro_tyls
proustites1246453proustites
proves114322253pro__ves
provides1439883provides
provokes1776603provokes
prowesses1437193prowesses
proxies163014933pro_xies
rentes65431193_r_entes
reties65436193_r_eties
retted74826313_r_etted
roomettes1146543roomettes
rootles73215633_rootles
roquettes1855063_roquettes
rosette7310373_rosette_
rotates72819773_rotates
rotes56143903_ro__tes
rotte54625933_ro_tte_
rotted74524433_ro_tted
rotten64115433_ro_tten
rotter64325463_ro_tter
rotters74421393_ro_tters
roulettes946523_roulettes
routes66129313_ro_utes
syrettes1136963syrettes
tonettes839203tonettes
trientes82812123trientes
trotted83711283tro_tted
trotter73312253tro_tter
trotters83310243tro_tters
vedettes1265943vedettes
videttes1266333videttes

Search took 8 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 Filter1786911461620.436409841.7
2DLD Change Limit1461622666.56322270.6
3Display Results2662660.1102418.2
 (SQL Overall)1786912667.10925135.9
 
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.